1)Liam has three other options for purchasing the Charles Street property. In the first scenario, he could borrow additional money to fund a renovation of the building. He wants to determine the monthly payment for the first scenario.
a)In cell G10, insert a formula using the
PMT
function using the monthly interest rate (cell
G6), the loan period in months (cell
G8), and the loan amount (cell
G4) to calculate the monthly payment for the renovation scenario.
![View<br>Insert<br>Format<br>Tools<br>Data<br>Window<br>Help<br>16%<br>Fri 3:57 PM<br>AutoSave<br>a SC_EX19_4a_AisetouMagassouba_1<br>OFF<br>...<br>Home<br>Insert<br>Draw<br>Page Layout<br>Formulas<br>Data<br>Review<br>View<br>O Tell me<br>A Share<br>Comments<br>2010<br>raw<br>Trebuchet MS (Bo...<br>Custom<br>Conditional Formatting<br>Insert v<br>11<br>V<br>Format as Table v<br>Delete v<br>B I U<br>$ v %<br>00<br>00 →0<br>Editing<br>Analyze<br>Data<br>Paste<br>Sensitivity<br>na<br>A Cell Styles v<br>Format v<br>G10<br>fx<br>1941<br>А<br>C<br>D<br>E<br>F<br>G<br>H<br>J<br>K<br>M<br>N<br>1 New Office Building<br>2 Loan Calculator<br>3<br>Loan Payment Calculator<br>Scenarios<br>Renovation<br>20 Years<br>8 Years<br>$ 1,020,000<br>4 Date<br>5 Property<br>6 Price<br>7 Down Payment<br>8 Loan Amount<br>9/15/21 Rate<br>4.45%<br>Loan Amount<br>(920,000)<br>Charles Street<br>Term in Months<br>180<br>Annual Interest Rate<br>4.45%<br>4.25%<br>4.45%<br>$<br>$<br>1,150,000 Monthly Payment<br>230,000 Total Interest<br>(920,000) Total Cost<br>$7,014.45<br>$ 2,182,601.29<br>$ 3,332,601.29<br>Month ly Interest Rate<br>Loan Period in Years<br>0.37%<br>0.35%<br>0.37%<br>15<br>20<br>8<br>it<br>Loan Period in Months<br>180<br>240<br>96<br>2 PM<br>9<br>Start Date<br>1/3/22<br>1/3/22<br>1/3/22<br>Varying Interest Rates and Terms<br>Number of Months<br>10<br>Monthly Payment<br>(6,000) $<br>(8,000)<br>11<br>Rate<br>Future Value<br>n/a<br>n/a<br>12 $<br>7,014<br>$<br>120<br>180<br>240<br>6,782.10 $<br>6,828.20 $<br>6,874.49 $<br>6,920.96 $<br>6,967.62 $<br>7,014.45 $<br>7,061.47 $<br>7,108.67 $<br>7,156.05 $<br>7,203.62 $<br>7,251.36 $<br>7,299.29 $<br>7,347.39 $<br>9,292.71<br>2$<br>3.95%<br>$<br>5,550.81<br>5,599.29<br>5,648.00<br>5,696.96<br>5,746.15<br>5,795.57<br>5,845.23<br>5,895.13<br>5,945.26<br>5,995.62<br>6,046.21<br>6,097.03<br>6,148.09<br>13<br>14<br>4.05%<br>9,336.43<br>9,380.28<br>9,424.25 $<br>$<br>2$<br>$<br>15<br>4.15%<br>t<br>16<br>4.25%<br>1 PM<br>9,468.35<br>9,512.58 $<br>2$<br>17<br>4.35%<br>18<br>4.45%<br>$<br>19<br>4.55%<br>9,556.92<br>9,601.40 $<br>$<br>20<br>4.65%<br>$<br>9,645.99<br>$<br>21<br>4.75%<br>$<br>9,690.71<br>2$<br>22<br>4.85%<br>9,735.56<br>9,780.53 $<br>$<br>23<br>4.95%<br>t<br>24<br>5.05%<br>$<br>5 PM<br>25<br>5.15%<br>9,825.62<br>26<br>27<br>28<br>29<br>30<br>ot<br>M CD<br>31<br>32<br>33<br>Documentation<br>Loan Calculator<br>Properties<br>Equipment Loan<br>+<br>Ready<br>+<br>100%<br>Special_Programs_<br>Transfer...est copy<br>1150 words<br>English (United States)<br>E ] Focus<br>+<br>180%<br>2022-02...3 PM CB 2022-02...2.39 PM 2022-02...7.00 PM<br>关<br>曲<br>](https://s3.us-east-1.amazonaws.com/storage.unifolks.com/qimg-008/008_2mpqxj0-3od0wspg.png)
Extracted text: View Insert Format Tools Data Window Help 16% Fri 3:57 PM AutoSave a SC_EX19_4a_AisetouMagassouba_1 OFF ... Home Insert Draw Page Layout Formulas Data Review View O Tell me A Share Comments 2010 raw Trebuchet MS (Bo... Custom Conditional Formatting Insert v 11 V Format as Table v Delete v B I U $ v % 00 00 →0 Editing Analyze Data Paste Sensitivity na A Cell Styles v Format v G10 fx 1941 А C D E F G H J K M N 1 New Office Building 2 Loan Calculator 3 Loan Payment Calculator Scenarios Renovation 20 Years 8 Years $ 1,020,000 4 Date 5 Property 6 Price 7 Down Payment 8 Loan Amount 9/15/21 Rate 4.45% Loan Amount (920,000) Charles Street Term in Months 180 Annual Interest Rate 4.45% 4.25% 4.45% $ $ 1,150,000 Monthly Payment 230,000 Total Interest (920,000) Total Cost $7,014.45 $ 2,182,601.29 $ 3,332,601.29 Month ly Interest Rate Loan Period in Years 0.37% 0.35% 0.37% 15 20 8 it Loan Period in Months 180 240 96 2 PM 9 Start Date 1/3/22 1/3/22 1/3/22 Varying Interest Rates and Terms Number of Months 10 Monthly Payment (6,000) $ (8,000) 11 Rate Future Value n/a n/a 12 $ 7,014 $ 120 180 240 6,782.10 $ 6,828.20 $ 6,874.49 $ 6,920.96 $ 6,967.62 $ 7,014.45 $ 7,061.47 $ 7,108.67 $ 7,156.05 $ 7,203.62 $ 7,251.36 $ 7,299.29 $ 7,347.39 $ 9,292.71 2$ 3.95% $ 5,550.81 5,599.29 5,648.00 5,696.96 5,746.15 5,795.57 5,845.23 5,895.13 5,945.26 5,995.62 6,046.21 6,097.03 6,148.09 13 14 4.05% 9,336.43 9,380.28 9,424.25 $ $ 2$ $ 15 4.15% t 16 4.25% 1 PM 9,468.35 9,512.58 $ 2$ 17 4.35% 18 4.45% $ 19 4.55% 9,556.92 9,601.40 $ $ 20 4.65% $ 9,645.99 $ 21 4.75% $ 9,690.71 2$ 22 4.85% 9,735.56 9,780.53 $ $ 23 4.95% t 24 5.05% $ 5 PM 25 5.15% 9,825.62 26 27 28 29 30 ot M CD 31 32 33 Documentation Loan Calculator Properties Equipment Loan + Ready + 100% Special_Programs_ Transfer...est copy 1150 words English (United States) E ] Focus + 180% 2022-02...3 PM CB 2022-02...2.39 PM 2022-02...7.00 PM 关 曲