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 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
Get step-by-step solutions from verified subject matter experts
