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)(1)

2. Interest paid between two months(1)

3. Principal paid between two months(1)

4. Balance owing (Settlement amount) at a specified month(1)

5. Initial payment if growth starts at a given point in time (arithmetic growth)(2)

Consider the growth for the next few calculations:

6. Interest paid between two months(1)

7. Principal paid between two months(1)

8. Balance owing (Settlement amount) at a specified month(1)

Exclude growth from the following questions.

9. Initial payment if payments are suspended between two periods{2)

Consider the suspension of payments for the next few calculations:

10. Interest paid between two periods(1)

11. Principal paid between two periods(1)

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

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

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

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!