Complete the spreadsheet provided and show all calculations in excel.

Excel Assignment Test Exercise Solution F332 NPV Analysis Purchase Price: Property: A $ 125,000 Solution Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Acquisition Purchase Price Closing Costs Downpayment Equity Investment $ $ $ $ 125,000 2,500 31,250 33,750 Cash Flow NOI Debt Service BTCF Principal Paid usius $ $ $ 18,517 $ (7,248) $ 11,269 $ (1,709) $ 18,980 S (7,248) $ 11,732 $ (1,811) $ 19,454 $ 17,248) $ 12,206 $ (1,920) $ 19,941 $ (7,248) $ 12,692 $ (2,035) S 20,439 (7,248) 13,191 (2,157) Sale Proceeds Sale Price $ Cost of Sale $ Loan Payoffs Sale Proceeds $ 137,977 9,658 84,118 44,201 $ 10,244 $ 9,695 $ 9,171 $ 8,669 $ 35,636 Present Value Sum PV 73,415 $ $ NPV 39,665 Growth Rate in NOI Sale Price Discount Rate Closing Costs (Aca) Cost of Sale 2.50% Growth 137,977 10.0% 2.00% 7.00% Ratios ROI Going in Cap Rate 1% 14.81% Mortgage Terms Interest Rate LTV Term 6.00% 75% 25 Excel Assignment Test Exercise Solution F332 NPV Analysis Purchase Price: Property: A $ 125,000 Solution Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Acquisition Purchase Price Closing Costs Downpayment Equity Investment $ $ $ $ 125,000 2,500 31,250 33,750 Cash Flow NOI Debt Service BTCF Principal Paid usius $ $ $ 18,517 $ (7,248) $ 11,269 $ (1,709) $ 18,980 S (7,248) $ 11,732 $ (1,811) $ 19,454 $ 17,248) $ 12,206 $ (1,920) $ 19,941 $ (7,248) $ 12,692 $ (2,035) S 20,439 (7,248) 13,191 (2,157) Sale Proceeds Sale Price $ Cost of Sale $ Loan Payoffs Sale Proceeds $ 137,977 9,658 84,118 44,201 $ 10,244 $ 9,695 $ 9,171 $ 8,669 $ 35,636 Present Value Sum PV 73,415 $ $ NPV 39,665 Growth Rate in NOI Sale Price Discount Rate Closing Costs (Aca) Cost of Sale 2.50% Growth 137,977 10.0% 2.00% 7.00% Ratios ROI Going in Cap Rate 1% 14.81% Mortgage Terms Interest Rate LTV Term 6.00% 75% 25