WITH FORMULAS PLEASE (EXCEL SPREADSHEET)

12 On April 1, Lincoln Lumber borrowed $20,000 at 9% interest, due in 4 months. How much will they repay when the note comes due? 13 On January 1 , year 1 , you invest $20,000 one time in an Individual Retirement Account earning 6%. How much will you have when you retire in 40 years? 14 You want to have $1,000,000 when you retire in 40 years. At 9% return, how much would you have to put aside today to avoid making yearly contributions in the future, and still have the $1,000,000 ? 15 You want to have $1,000,000 when you retire in 40 years. At 10% return, how much would you have to put aside each year to have $1,000,000 in 40 years? 16 Your win $10,000 year for 20 years in the lottery. Assuming a 7% return per year, how much are the payments worth now? 17 ABC Company buys equipment for $20,000 down and $10,000/ year for 5 years. If interest rates are 7%/ year, how much should we record as the cost of the equipment