The writer is very fast, professional and responded to the review request fast also. Thank you.
Presentation/PPT
27/08/2022
This is an excel project I need help with:Using a spreadsheet program (Microsoft Excel) to solve all the problems given below. The Excel sheetshould be an active sheet – means the formula should be enabled in each cell, DO NOT just copy & pastethe values or manually input the values in the cells. If so, you will be awarded zero points. This projectwill help you become familiar with Excel and be useful in your future classes and even at work.PROBLEM # 1:You have just turned 22, and you intend to start saving for your retirement. You plan to retire in 40years when you turn 62. During your retirement you would like to have an annual income of $140,000per year for the next 30 years (until age 92).Calculate how much you would have to save annually between now and age 62 in order to finance yourretirement income.Make the following assumptions:• Assume that the relevant compounded interest rate is 9 percent per year.• You make the first payment today and the last payment on the day of your turn 62.• You make the first withdrawal when you turn 62 and the last withdrawal when you turn 92.PROBLEM # 2:You are offered an asset that costs $8,000 and has cash flows of $500 every three month (end of period)of the next 10 years.a) If your cost of capital is 8 percent, should you purchase it?b) What is the IRR of the asset?c) What is the NPV of the asset?(Setup cash flows in Excel spreadsheets and use the following Excel Financial functions, IRR and NPV, toderive your answers. Use your calculator to make sure that the answers are correct. Read chapter 19before you start doing the problem.)PROBLEM # 3:You just took a $50,000, eight-year loan. Payments at the end of each year are flat (equal in every year)at an interest rate of 8 percent. Calculate the appropriate loan table, showing the breakdown in eachyear between principal and interest.PROBLEM # 4:Use Excel to construct an amortization table for the following mortgage. In the amortization table,provide all the information listed below. (Assuming interest is compounded monthly and payments aredue at the end of the month).For a 10-year variable-rate-level-payment mortgage (VRM) of $480,000 with the following mortgagerates:Years 1-2: 4.20%, Years 3-5: 5.45%, Years 6-10: 6.75%Compute and illustrate the following in an amortization table:• Monthly Payment of the mortgage.• Mortgage Balance Remaining at the end of each month (Total 120 months)• Principal Repayment for each month.• Interest Expenses for each month and the life of the loan.(Hints: Monthly payments vary over time! Just repay the principle once!)
Show more
The writer is very fast, professional and responded to the review request fast also. Thank you.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more