use Excel please.

do it like this

PV

FV

PMT

N

I/Y

IN

1. A Real Estate Investor is considering the purchase of an apartment building. The investor estimates the current value at $400,000. If the market price appreciates at 8 percent annually what will be the price of the unit at the end of 5 years? 2. Suppose you were selling your home. A buyer has offered to pay you $115,000 now and another $85,000 in 2 years. What is the value today of the payment received in 2 years, given your required rate of return is 7 percent? 3. Suppose you have the option to buy a parcel of vacant land to build your first home. The option is for a 5-year period, and the purchase price is $65,000. You do not intend to exercise the option until the end of the 5th year, which means you have 5 years to accumulate the required $65,000 in cash to buy the land. Given you have access to a savings account that pays 6 percent interest that compounds annually, how much will you have to save each year? 4. What is the difference between an ordinary annuity and an annuity due? 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