
| Powered by
 Q. [help} decision analysis case study ? billy tan just graduated with a mechanical engineering degree and secured a new job with a starting annual salary of $36,000. there are a few things that he would like to do
with his newfound “wealth.”
as a fresh graduate, he needs to begin repaying his student loans (amounting to $20,000) and he also likes to reduce some outstanding balances on his credit cards (amounting to $5,000). billy also needs to purchase a car to get to work and would like
to put money aside to purchase a condominium in the future. last, but not least, he wants to put some money aside for his eventual retirement.
he would like to do some financial planning for which he has selected a 10year time frame. at the end of 10 years, he would like to have paid off his current student loan and credit card debt, as well as have accumulated $40,000 for a down payment on a condominium. if possible, billy would like to put aside 10% of his take home salary for
retirement. he has gathered the following information to assist him in his planning:
• student loans are typically repaid in equal monthly installments over a period of ten years. the interest rate on billy’s loan is 8% compounded monthly.
• the monthly minimum credit card payments are usually computed using a 10year repayment period. the interest rate on billy’s credit card is 18% compounded monthly.
• car loans are usually repaid over three, four, or five years. the interest rates on a car loan can be as low as 2.9% (if the timing is right) or as high as 12%. as a firsttime car buyer, billy can secure a $15,000 car loan at 9% compounded monthly to be repaid over
60 months.
• a 30year,fixed rate mortgage is currently going for 5.75% to 6.0% per year. if billy can save enough to make a 20% down payment on the purchase of his condominium, he can avoid private mortgage insurance that can cost as much as $60 per month.
• investment opportunities can provide variable returns. “safe” investments can guarantee 7% per year, while “risky” investments could return 30% or more per year.
• billy’s parents and older siblings have reminded him that his monthly takehome pay will be reduced by income taxes and benefit deductions. he should not count on being able to spend more than 80% of his gross salary.
additional requirements:
a) after billy’s car is paid off, he plans to continue setting aside the amount of his car payment to accumulate funds for the car’s replacement. if he invests this amount at rate of 3% compounded monthly, how much will he have saved by the end of the initial 10year
period?
b) billy has planned to have $40 000 at the end of ten years to place a down payment on a condo. property taxes and insurance can be as much as 30% of the monthly principal and interest payment (i.e. for a principal and interest payment of $1000, taxes and insurance would be an additional $300). what is the maximum purchase price he can afford if he would like to keep his housing
costs at $950 per month?
c) if billy is more daring with this retirement investment savings and feels he can average 10% per year, how much will he have accumulated for retirement at the end of the 10year
period?
as billy’s friend, you have been asked to review his financial plans. how reasonable are his goals? support your findings with appropriate computations using excel and prepare
a powerpoint presentation for your client. state your assumptions clearly.
i need ur help . thx
This problem is a multi-faceted one that requires a few different calculations having to do with the future value of annuities. if your working problems like this you have the tools necessary to figure them out. with that being said, I have a peice of advice for you. Don't in any way associate this person with yourself, real life never acts like the calculations in your college textbooks. Don't make this your financial plan - remember personal finance is 90% bahavior. 5% plan and 5% luck. good luck
|