Categories
Finance

Janet Stein wants to buy a food truck when she graduates from college in two yea

Need Help With your assignment? Get expert academic writing assistance! We can write any paper on any subject within the tightest time.

Hire A Writer

Janet Stein wants to buy a food truck when she graduates from college in two years. She has the following sources of money:
She has $6000 in the bank in an account paying 8% compounded quarterly.
She will receive $3000 in one year from a trust.
She will take a business loan out at the time of purchase on which she will make monthly payments of $500 at 18% compounded monthly over 4 years.
Janet’s uncle is going to give $1,600 a quarter starting today for one year. In addition, Janet will save up money in a credit union through monthly payroll deductions at her part time job. The credit union pays 10% compounded monthly.
If the truck is expected to cost $40,000, how much must she save each month?
Janet’s uncle would like a detailed plan outlining the amount of money she will have saved each year. As Janet’s finance advisor, she is asking you to help her calculate the amount of money she will have over the next two years and explain to her uncle how utilizing the present value future value concepts, along with planning, will assist Janet in her food truck buying decision.
Report your annual calculations using Excel and write a 1–2-page memo to her uncle detailing the analysis component.
Submit your Excel spreadsheet with calculations. Submit a 1–2-page summary of your analysis. Describe the amount of money she will have saved each year over the next two years and explain how utilizing the present value future value concepts, along with planning, will assist Janet in her car-buying decision.

Need Help With your assignment? Get expert academic writing assistance! We can write any paper on any subject within the tightest time.

Hire A Writer

Leave a Reply