use excel, please do it like this

PV=

FV=

PMT=

N=

I/Y=

IN=

You are a landlord and have decided for your tenants to contribute $1,000 a month towards rent payable on the first day of each month. If you deposit each rental payment into an interest bearing account that pays an annual rate of 7 percent, but is compounded monthly, how much will be in the account at the end of 12 months? 5. You decide to replace the existing roof on your house for a cost of $25,000. You decide to save $1,200 per month in an account that pays 4 percent annual interest, compounded monthly. In how many months would you have enough saved in the account to purchase a new roof? 6. 7. Suppose you are a mortgage lender. A borrower has promised to pay you $11,746 each year for 20 years. Given you want to earn a 10 percent rate of return per year, what is the most you are willing to lend the borrower? You are thinking about letting a friend borrow $10,000 today given that she will repay you $15,000 in 5 years. What is your internal rate of return on the investment? 8