I need help with the following excel document.


Question Description:

35

I need help with the following excel document. Accounting Midterm 987.xls Midterm Exam, 2014 Name Question 1 2 3 4 5 6 7 8 9 10 Late Total Score 0 0 0 0 0 0 0 0 0 0 0 0 Question 1 Score Joice has saved $5,000 that will be a down payment on a new car that can be purchased for $38,000. a The loan to finance this will have a rate of 7.125% APR compounded monthly. What will the monthly payments on the car be if the loan is for 4 years?? b How long would it take to pay off the loan if she would pay $1,000 monthly? c Joice has been offered a lease for this car with payments of $600 a month for 5 years. There would not be any down payment. As happens with leases, she would essentially receive the full value of the car today and she would return the car to the dealer at the end of the lease (essentially paying out the value of the car at that time). The value of this car in 5 years, with no damage or excessive mileage, is expected to be $12,000. What APR with monthly compounding would she be paying? Solution Question 2 Score Tony has decided to make a $500 monthly investment in a retirement fund. The three funds in which he is interested all pay 2.00% APR but with different compounding frequencies.. How much will Tony accumulate in 30 years for each of the three investment alternatives? a Interest of 2.00% APR compounded weekly (52 times per year) b Interest of 2.00% APR compounded monthly (12 times per year) c Interest of 2.00% APR compounded annually (1 time per year) Solution Question 3 Score Peter has won $250,000 in a lottery that he is going to invest. He has narrowed down his search to three funds that each have different stated rates. How much will Peter accumulate in 30 years for each of the three investment alternatives? a b c 6.15% APR with monthly compounding 0.50% monthly PIR 6.25% EAR Solution Question 4 Score Jackson is considering whether to invest monthly, quarterly or annually in a fund that earns 7% APR with monthly compounding. How much will Jackson accumulate in 30 years for each of the three investment alternatives shown below? Assume that months are equal in length and that there is no initial deposit in year 0. Years APR Alternative a b c Solution 30 7.00% Monthly Quarterly Annually Monthly Compounding Payments $500 $1,500 $6,000 Question 5 Score Cheapskate used car dealer offers the following automobile finance opportunity. Monthly payments on the loan are 3% of the loan amount for 36 months. The loan amount is after any down payment. In addition the loan will require a $1,500 up front loan processing fee that is not included in the loan. a For a loan of $20,000, what is the APR with monthly compounding without the up front fee? b For a loan of $20,000, what is the APR with monthly compounding with the inclusion of the up front fee? Solution Question 6 Score Michael has developed a financial retirement strategy. His plan is to invest in somewhat risky stocks for 15 years and then move everything to low risk bonds for the retirement years as described below. Michael presently has $250,000 in a retirement account that will be invested in a stock fund that has historically earned 12% annually (EAR) with no dividends. The plan is to add an additional $25,000 to the fund at the beginning of each of the upcoming 15 years. When he retires, he will reinvest the stock fund in a tax-free municipal bonds and live on the coupons only that have a coupon rate of 2.5% paid semi-annually. (the bonds will be donated to charity upon his death). How much will Michael receive semi-annually during retirement? Solution Question 7 Score Max is starting a new company with an investment of $500,000. He expects sales to grow arithmetically by $100,000 a year for five years, with sales in year 1 being $100,000, year 2 $200,000, etc.. Then for years 6-10 sales are forecast to grow geometrically at a rate of 30% per year (year 6 sales grow 30% over year 5, year 7 30% over year 6, etc.) At the end of

Answer

35