Question

In: Economics

you owe your best friend $2000. because you are short on cash, you offer to repay...


you owe your best friend $2000. because you are short on cash, you offer to repay the loan over 12 months under the following condition. the first payment will be $100 at the end of month one. the second payment will be $100+G at the end of month two. at the end of month three, you'll repay $100+2G. this pattern of increasing G amounts will continue for all remaining months.
a. what is the value of G if the interest rate is 0.5 per month?
b. what is the equivalent uniform monthly payment?
c. repeat part (a) when the first payment is $150 (i.e., determine G)

Solutions

Expert Solution

a

We know that

Total loan today = 2000

Here it is difficult to understand that the interest rate is 0.5 or 0.5 per cent

I am solving this question as an interest of 0.5% please let me know in comments if you need it to solve as 0.5 per month

Now,

To solve this question we will use excel and create a model as follows

Now,

As we can see that the payment G = 13.258

But to get this number we did iteration

The first column is the serial number

The second column is the amount left which is calculated using the formula

Amount left = The amount left in the previous month - Fix payment - nG + Interest

Interest is calculated using the following formula

Interest = Amount due * 0.005

After doing multiple iterations we can find the value of G

b

This question can be solved using the formula PMT in excel

The inputs are as follows

rate = 0.005

nper = 12

PV = -2000

The output

PMT = 172.13

Thus the uniform monthly payment to pay the loan is 172.13

c

The question can be solved by the same model used to solve part a. However, at the place of 100, we use 150 as fixed payment and therefore the value of G will be as follows

Hence, G = 4.068


Related Solutions

You owe your best friend $2,700. Because you are short on cash, you offer to repay...
You owe your best friend $2,700. Because you are short on cash, you offer to repay the loan over 10 months under the following condition. The first payment will be $90 at the end of month one. The second payment will be $90+ G at the end of month two. At the end of month three, you'll repay $90+2G. This pattern of increasing G amounts will continue for all remaining months. a. What is the value of G if the...
you lend a friend 25,000, which your friend will repay in 14 equal annual end of...
you lend a friend 25,000, which your friend will repay in 14 equal annual end of year payments of $4,000 w/ the first payment to be recieved 1 yr from now. ehat rate does your loan recieve ?
You owe your parents $28,000 (in present day dollars) and want to repay them in equal...
You owe your parents $28,000 (in present day dollars) and want to repay them in equal amounts the first to occur in 3 years from today and the other in 8 years from today. If the interest rate is 10.9% per annum compounding monthly, what will be the amount of each repayment? Select one: a. $24520 b. $38774 c. $66705 d. $38191
You owe $2000 on a credit card that charges 20% interest. You have $2200 in your...
You owe $2000 on a credit card that charges 20% interest. You have $2200 in your savings account that earns 1.69% interest. Your savings account charges $14.50 a month if you keep a balance of less than $1500 a month. Compare the amount of interest for both to decide what you should do about paying the credit card bill. Consider all factors in the decision. Show your for any calculations you may completed.
You owe 2000 dollars on your credit card which has an interest rate of 18% per...
You owe 2000 dollars on your credit card which has an interest rate of 18% per year compounded monthly. If you plan to pay it off in 4 years, what are your monthly payments? 2 decimals What are the total payments? Round to nearest whole dollar. How much total interest is paid? Nearest whole dollar. What is the unpaid balance after 1 year? Round to nearest whole dollar.
Your best friend is the CFO for a publicly traded corporation. He (illegally) tells you that...
Your best friend is the CFO for a publicly traded corporation. He (illegally) tells you that the company had a surprisingly good quarter, and advises you to buy the stock before the earnings are reported next week. You purchase the stock, but to your surprise, the price does not increase in the days after the earnings announcement. This is an example of which form of market efficiency? Group of answer choices Technical Form Semi-Strong Form Strong Form
Your best friend knows that you are currently taking an accounting class, and he comes to...
Your best friend knows that you are currently taking an accounting class, and he comes to you for some advice. He is interested in using his savings to purchase stock in a public corporation. He downloaded the annual report for two retail companies. He has the following questions about the two retail companies: What is typically included in each statement? Why do the statements appear in the following order? Income Statement Retained Earnings Statement Balance Sheet Cash Flow Statement What...
1.  Ismael, your best friend, has been offered a position at your company. Both of you are...
1.  Ismael, your best friend, has been offered a position at your company. Both of you are excited about his job because it is a great opportunity, and you will be able to share a ride to work. Once you learn about the position he is accepted, you are concerned. You are where the qualifications for the position, and you know that is my Ismael doesn't have some of the qualifications. You suspect that Ismael may have stretched the truth about...
A. Your best friend has asked to assist him in making the best investment out of...
A. Your best friend has asked to assist him in making the best investment out of the following options. Which would you advise him to choose and why? SHOW WORKINGS TO JUSTIFY YOUR ANSWER. Option 1: $12,000 in 5 years’ time at 6 percent interest. Option 2: $15,000 in 2 years’ time at 9 percent interest. Option 3: $15,000 today. No strings attached. Option 4: $5,000 each year for 2 years at 7 percent interest compounded semi-annually. B. Betty Kay...
Your best friend consults you for investment advice. You learn that his tax rate is 30...
Your best friend consults you for investment advice. You learn that his tax rate is 30 %​, and he has the following current investments and​ debts: - A car loan with an outstanding balance of $ 5,000 and a 4.85 % APR​ (monthly compounding) - Credit cards with an outstanding balance of $ 10,000 and a 14.99 % APR​ (monthly compounding) - A regular savings account with a $ 30,000 ​balance, paying a 5.51 % effective annual rate​ (EAR) -...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT