Reference no: EM131201288
Intermediate Financial Management Excel Project Instructions
You will use a spreadsheet program (Microsoft Excel) to solve all the problems given below.
PROBLEM 1:
You have just turned 22, and you intend to start saving for your retirement. You plan to retire in 41 years when you turn 63. During your retirement you would like to have an annual income of $165,000 per year for the next 28 years (until age 91).
- Calculate how much has to be in your account before the first withdrawal at age 64.
- Calculate how much would have to save annually between now and age 63 in order to finance your retirement income and to fill that account.
Make the following assumptions:
- Assume that the relevant compounded interest rate is 9 percent for all 69 years.
- You make the first payment today and the last payment on the day you turn 63.
- You make the first withdrawal when you turn 64 and the last withdrawal when you turn 91.
PROBLEM 2:
You just took a $125,000, seven-year loan. Payments at the end of each month are flat (equal in every month) at an annual interest rate of 4.75 percent.
- Calculate the monthly payment.
- Provide the appropriate loan table, showing the breakdown in each month between principal repayment and interest.
PROBLEM 3:
You are offered an asset that costs $14,000 and has cash flows as follows below at the end of each quarter for the next 8 years. Then it will be sold for $2,500. Your cost of capital is 6.5 percent. An alternative (mutually exclusive) project is available which offers an accounting rate of return of 8%, a classical payback period of 5 years and a discounted payback period of 5 years.
Year 1: $800 each quarter
Year 2: $850 each quarter
Year 3: $850 each quarter
Year 4: $950 each quarter
Year 5: $800 each quarter
Year 6: $600 each quarter
Year 7: $500 each quarter
Year 8: $400 each quarter
a) What is the IRR of the asset?
b) What is the NPV of the asset?
c) What are the PI and NPI of the asset?
d) What are the classical and discounted payback periods?
e) What are the four accounting rate of returns (utilizing cash flows)?
f) Should you purchase it?
|
Find the generated voltage per phase
: If the machine is operating at rated load and voltage at a power factor of 0.867 lagging, find the generated voltage per phase and the torque angle.
|
|
Prepare adjusting journal entries on december 31 2007
: Correcting Entries for Patents During the year-end audit of the Cressman Corporation's financial statements for 2007, - Prepare adjusting journal entries on December 31, 2007.
|
|
Find the armature current
: A 10-hp, 230-V, 60 Hz, three-phase wye-connected synchronous motor delivers full load at a power factor of 0.8 leading. The synchronous reactance is 6 Ω, the rotational loss is 230 W, and the field loss is 50 W.
|
|
How many juice boxes does lucy have
: Oliver has one juice box. - Lucy has one fewer juice box than Oliver. - how many juice boxes does lucy have?
|
|
Calculate the monthly payment
: You just took a $125,000, seven-year loan. Payments at the end of each month are flat (equal in every month) at an annual interest rate of 4.75 percent. Calculate the monthly payment
|
|
What is line current and is it leading or lagging voltage
: what is the line current, and is it leading or lagging the voltage?
|
|
What type of targeting strategy is the promark company using
: When Ikea showcases rooms of furniture on its website, it lists each item in the room. However, if customers like all of the items, they can purchase them as a bundle. Which of the following aspects of the marketing mix is Ikea likely altering?
|
|
What are the diagrams defined in the uml standard
: Why does the following code give a compiler error? How should it be fixed? What are the diagrams defined in the UML Standard. Give a one or two sentence description of each one.
|
|
Identify two situational pressures in a public company
: Identify two situational pressures in a public company that would increase the likelihood of fraud.- Identify three opportunity situations that would increase the likelihood of fraud.
|