Question: How exactly do I go about doing this? Need urgent held The task is to develop a model that will calculate the following aspects of

How exactly do I go about doing this? Need urgent held

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                                                                           

11. Principal paid between two periods                                                                                      

12. Balance owing (Settlement amount) at a specified period                                                

Design and User friendliness of the model (decent attempt, good attempt, very good)    

Innovation (bonus functionality and approaches)   (little, good, very good)                          


Step by Step Solution

3.50 Rating (150 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Assuming you want a pseudo code answer 1 Ask the user for the amount of the loan the interest rate the term of the loan in years and whether they want their monthly payment to be at the beginning or e... View full answer

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!