This commento 315,000 for the first year entgrowth Amet tona $160.000 with 15.00 hongo525.00 performer der of SAS Insurance 5950 anys per the come tot 21 percent whes for segment 2 center. The power of a pery A heart It See of percent wordt Be sure to show your hero, de moeither priorcs when iting in your mind the horfor owner of womento comparable, which is the betinget Part 1: Property and Loan Information A rain the table for the property in in the table for the loan formation the action to the payment Part 2: Loan Schedule C Fat in the table for the loan schedule over five years. Make sure you reference or to payment and periodic tel. 8 points Dj Feat in the table for the yearly summary of the anschede Fat in the table for the yearly property data. Acolyte Pformata in the correct growthres (8 points) Part 3: Cash Flow Analysis F Fill in the table for the before tax cash flows from owning points Gira in the table for tax deductions. points) H1 Fill in the table for net cash flows from owning 18 points) Fun in the table for the cash flows from selling the home in years. (8 points) J) in the table for the net cash flows. Assume no taxes are dve on the benefit from sale. Calculate the internal rate of return (RR) using the Excel function. (8 points) 1,254 Rent versus Own Analysis $15,000 for the first year, with an annual 2 percent rental growth rate. Alternatively, it can purchased for This project requires you to compare renting versus Owning a home. Assume the home can be rented for $ 160,000 with a $35,000 down payment and financed with a fully amortizing mortgage loan of $125,000 insurance costs of $350, and property taxes of 3.5 percent of the purchase price. Assume the income tax , are equal to 2.5 percent per year. The property value will grow at a rate of a constant 1.8 percent per year. After five years, the property will be sold. Selling expenses of 6 percent would have to be paid at that time. Be sure to show your work in Excel. In other words, do not simply type values into the boxes, but reference prior cells when calculating results in your report, identify and explain the cash flow in each year, for owning relative to renting. If an annual after tax return of 20 percent is available on an investment of comparable risk, which is the better option, owning or renting? Part 1: Property and Loan Information A) Fill in the table for the property information. (8 points) B) Fill in the table for the loan information. Use the Excel PMT function to calculate the monthly payment. (8 points) Part 2: Loan Schedule C) Fill in the table for the loan schedule over five years. Make sure you reference cells (e.g., monthly payment and periodic rate). (8 points) D) Fill in the table for the yearly summary of the loan schedule. (8 points) E) Fill in the table for the yearly property data. Apply the FV formula using the correct growth rates, (8 points) 2. Cash Flow Analysis This commento 315,000 for the first year entgrowth Amet tona $160.000 with 15.00 hongo525.00 performer der of SAS Insurance 5950 anys per the come tot 21 percent whes for segment 2 center. The power of a pery A heart It See of percent wordt Be sure to show your hero, de moeither priorcs when iting in your mind the horfor owner of womento comparable, which is the betinget Part 1: Property and Loan Information A rain the table for the property in in the table for the loan formation the action to the payment Part 2: Loan Schedule C Fat in the table for the loan schedule over five years. Make sure you reference or to payment and periodic tel. 8 points Dj Feat in the table for the yearly summary of the anschede Fat in the table for the yearly property data. Acolyte Pformata in the correct growthres (8 points) Part 3: Cash Flow Analysis F Fill in the table for the before tax cash flows from owning points Gira in the table for tax deductions. points) H1 Fill in the table for net cash flows from owning 18 points) Fun in the table for the cash flows from selling the home in years. (8 points) J) in the table for the net cash flows. Assume no taxes are dve on the benefit from sale. Calculate the internal rate of return (RR) using the Excel function. (8 points) 1,254 Rent versus Own Analysis $15,000 for the first year, with an annual 2 percent rental growth rate. Alternatively, it can purchased for This project requires you to compare renting versus Owning a home. Assume the home can be rented for $ 160,000 with a $35,000 down payment and financed with a fully amortizing mortgage loan of $125,000 insurance costs of $350, and property taxes of 3.5 percent of the purchase price. Assume the income tax , are equal to 2.5 percent per year. The property value will grow at a rate of a constant 1.8 percent per year. After five years, the property will be sold. Selling expenses of 6 percent would have to be paid at that time. Be sure to show your work in Excel. In other words, do not simply type values into the boxes, but reference prior cells when calculating results in your report, identify and explain the cash flow in each year, for owning relative to renting. If an annual after tax return of 20 percent is available on an investment of comparable risk, which is the better option, owning or renting? Part 1: Property and Loan Information A) Fill in the table for the property information. (8 points) B) Fill in the table for the loan information. Use the Excel PMT function to calculate the monthly payment. (8 points) Part 2: Loan Schedule C) Fill in the table for the loan schedule over five years. Make sure you reference cells (e.g., monthly payment and periodic rate). (8 points) D) Fill in the table for the yearly summary of the loan schedule. (8 points) E) Fill in the table for the yearly property data. Apply the FV formula using the correct growth rates, (8 points) 2. Cash Flow Analysis