Question: I need assistance in creating a financial model on excel. The task is to develop a model that will calculate the following aspects of TVM

I need assistance in creating a financial model on excel. The taskI need assistance in creating a financial model on excel.

The task is to develop a model that will calculate the following aspects of TVM for a user: 1. Monthly payment (incorporate ability to shift between beginning or end of month) 2. Interest paid between two months 3. Principal paid between two months 4. Balance owing (Settlement amount) at a specified month 5. Initial payment if growth starts at a given point in time (arithmetic growth) Consider the growth for the next few calculations:| 6. Interest paid between two months 7. Principal paid between two months 8. Balance owing (Settlement amount) at a specified month Exclude growth from the following questions. 9. Initial payment if payments are suspended between two periods Consider the suspension of payments for the next few calculations: 10. Interest paid between two periods (1) 11. Principal paid between two periods 12. Balance owing (Settlement amount) at a specified period Design and User friendliness of the model Innovation The task is to develop a model that will calculate the following aspects of TVM for a user: 1. Monthly payment (incorporate ability to shift between beginning or end of month) 2. Interest paid between two months 3. Principal paid between two months 4. Balance owing (Settlement amount) at a specified month 5. Initial payment if growth starts at a given point in time (arithmetic growth) Consider the growth for the next few calculations:| 6. Interest paid between two months 7. Principal paid between two months 8. Balance owing (Settlement amount) at a specified month Exclude growth from the following questions. 9. Initial payment if payments are suspended between two periods Consider the suspension of payments for the next few calculations: 10. Interest paid between two periods (1) 11. Principal paid between two periods 12. Balance owing (Settlement amount) at a specified period Design and User friendliness of the model Innovation

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 Accounting Questions!