Question

SOLVE WITH EXCEL FUNCTIONS: A loan must be canceled monthly in 3 years like this: twelve...

SOLVE WITH EXCEL FUNCTIONS: A loan must be canceled monthly in 3 years like this: twelve equal monthly installments in the first year of $ 5,000, the thirteenth installment is the 12th installment decreased by $ 250 and so on they will decrease in the same amount until the month 24. The 25th installment It is the 24 installment increased by $ 300 and so will continue to increase by $ 300 until month 36. Find the value of the loan if the interest is 2% monthly.

Homework Answers

Answer #1

Given

interest rate r=2% monthly

Loan Value = Present Value of 1st year instalment + Present Value of 2nd year instalment +Present Value of 3rd year instalment

1st year instalment A1=$5000

Present Value of 1st year instalment= 5000*(1-(1+2%)^-12)/2%=$52876.71

Month Instalment PV of Instalment
13 4750 3671.90
14 4500 3410.44
15 4250 3157.81
16 4000 2913.78
17 3750 2678.11
18 3500 2450.56
19 3250 2230.90
20 3000 2018.91
21 2750 1814.38
22 2500 1617.10
23 2250 1426.85
24 2000 1243.44
PV of 2nd year 28634.19
Month Instalment PV of Instlment
25 2300 1401.92
26 2600 1553.71
27 2900 1699.00
28 3200 1838.00
29 3500 1970.89
30 3800 2097.87
31 4100 2219.11
32 4400 2334.79
33 4700 2445.08
34 5000 2550.14
35 5300 2650.15
36 5600 2745.25
PV of 3rd year 25505.89

Loan Value = Present Value of 1st year instalment + Present Value of 2nd year instalment +Present Value of 3rd year instalment =52876.71+28634.19+25505.89=$107016.80

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
a. [3 pts] Consider the simple loan case. Suppose that the dealership allows you to pay...
a. [3 pts] Consider the simple loan case. Suppose that the dealership allows you to pay the car off in four installments of $5,000, with each installment due once a year. The first payment is due the day that you purchase the car; the remaining installments are then paid on the same date each consecutive year, for the remaining three years. What is the present discounted value of the payments you make for the car? b. [5 pts] Now suppose...
My assignment is to create a roadmap to and for retirement for the people in the...
My assignment is to create a roadmap to and for retirement for the people in the following case study. I am looking for some ideas of how to tackle this one, not expecting you to write it for me. Thank you so much! Case Study: Bruce and Faith Johnston, 64 and 58, are preparing for retirement within two years. Other short-term financial goals of theirs are to pay off almost $12,000 of outstanding debt on credit cards and spend $5,000...
SECTION A: READ THE PASSAGE AND ANSWER QUESTIONS 1-3 Emma, a monthly salaried worker, received 1,300...
SECTION A: READ THE PASSAGE AND ANSWER QUESTIONS 1-3 Emma, a monthly salaried worker, received 1,300 cedis as her net salary; she heard that this year’s inflation is at 18%. This situation caused prices to soar so high that she complained about everything she buys. In the previous year she was able to buy herself, dresses, a basket of foodstuffs, a small bag of oranges, a dozen of drinks and her transportation. However, this year, she couldn’t afford the full...
Months into the COVID-19 pandemic, which continues to affect a growing number of countries and people,...
Months into the COVID-19 pandemic, which continues to affect a growing number of countries and people, 1 the responses to our newest McKinsey Global Survey on economic sentiment confirm the extent of the damage so far. 2 Respondents are much likelier now than in March (52 percent, up from 10 percent) to say their countries’ economies have declined substantially in recent months, and more than twice as likely to report substantially worse conditions in the global economy. Across geographies, vast...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...