Question: please solve using Microsoft Excel (MSExcel) assistance Jane just finished her undergraduate study from a university. Immediately after finished her study, she begins to work

 please solve using Microsoft Excel (MSExcel) assistance Jane just finished her

please solve using Microsoft Excel (MSExcel) assistance

Jane just finished her undergraduate study from a university. Immediately after finished her study, she begins to work to a workplace that offers the salary (without any deduction) of $2,500 per month. Her salary increases by $300 per year. She plans to commit to this workplace for 30 years. Calculate the total salaries over her entire service. Meanwhile, she owns a house valued at $300,000 cost. She purchases a full loan to buy this property for 30 years at the rate of 4.5% interest per annum convertible monthly. Calculate her monthly instalment of the housing loan, and the charge of interest she may bear the cost over 30 years. After deducting the loan instalment, the remaining of her monthly salary would be her expenditure. During her service to the workplace, she plans to limit her monthly expenditure up to 60% of her salary. She then plans to save her remaining income into her retirement plan. Present your work on how to determine the time (in year and month) she may begin to save her money. The retirement plan offers an effective rate of 10% dividend per annum. Propose your work on how to attain her accumulated fund during retirement. Determine the amount of fund at the end of her retirement year. Jane also plans to make a full settlement of her housing loan earlier. She may use 50 percent of her current retirement fund to sufficiently pay out the loan balance. Solve on how to determine the time (in year and month) she settles her loan

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!