Question

In: Finance

Problem 3 A) Pierluigi is trying to get a loan for $10,000 to start a business...

Problem 3 A) Pierluigi is trying to get a loan for $10,000 to start a business as a financial advisor and is trying to decide between several options. (15 points)

i) A $10,000 loan that needs to be paid back after 5 years with a 5% nominal annual interest rate, compounded monthly.

ii) A $10,000 loan that needs to be paid back after 6 years, the first 2 years there is no interest, and after the annual effective interest rate is 10%. Hint: When solving for the annual payment consider PV=A+A+A(P/A,i%,n) where A is the uniform annual payment.

Assuming that in each case he plans to make equal yearly payments for the full length of the loan, starting in year 1:

  1. What is the amount of his yearly payment in each case? (2*5 points)
  2. Now assume that the interest rate of the market is an effective annual rate of 3%, what is the present value of the annuity payments for each option? Based on this metric, which is better? (4+1 points

PLEASE BE DETAILED IN YOUR EXPLANATION, THANK YOU!

Solutions

Expert Solution

a.
i.   Equal yearly payments for the 5 years
Using PV of annuity formula,
10000=Pmt.*(1-(1+r)^-n)/r)
where, PV= the value of the loan amt.= $ 10000
Pmt.= Mthly. payment to be found out & converted to annual
r= mthly compounding rate of interest ,ie.(5%/12)
n=No.of compounding periods= 12*5 yrs.=60
Plugging in the above values,
10000=Pmt.*(1-(1+(0.05/12))^-60)/(0.05/12)
& solving for pmt. We get the monthly payment as
Pmt.= $ 188.71
So, yearly payment is
188.71*12=
2264.52
Or
2265
ii.As the cash outflows start at end of Yr. 3 only,first,we need to find the PV of the Cash flows
Year 1 2 3 4 5 6
Cash flows for this loan 0 0 1000 1000 1000 11000
PV of the above cash flows= (1000/1.1^3)+(1000/1.1^4)+(1000/1.1^5)+(11000/1.1^6)=
8264.46
Or
8264
Now with this PV we find the annual PMT. Given 10% interest rate ,using the above formula for PV
ie.8264=Pmt.(1-1.1^-6)/0.1
Solving for pmt., we get the uniform annual payment as
1897.48
or
1897
b..
Given the interest rate of the market is an effective annual rate of 3%,
PV of Option i=
188.71*(1-(1+(0.03/12))^-60)/(0.03/12)=
10502.15642
OR
10502
PV of Option ii=
1897*(1-1.03^-6)/0.03=
10276.41
OR
10276
Option ii is a better option as the PV of future cash flows is the lesser of the two.

Related Solutions

You are given a $200,000 loan to start a business with the interest rate of 3%....
You are given a $200,000 loan to start a business with the interest rate of 3%. How would you invest this money to be able to pay back the loan in 5 years and also make as much profit as you can? Describe the type of business that you would start and include the estimation of one-time cost and recurring cost. Your projects cannot be similar; otherwise, all similar projects will receive zero credit. Show your calculations; explain the basis...
I'm trying to make this C++ loan calculator but I can't get the program to output...
I'm trying to make this C++ loan calculator but I can't get the program to output what I need. For instance I know the formula is right and when I enter 100000 1.5 20 as my cin variables I should get 482.55 but I get 1543.31. What am I not seeing as the issue? Also this should cout only 2 decimal places right? I'm not allowed to alter the #include and add any fixed setprecision. This is what I have....
A person planned to start a business venture in Muscat and decided to borrow a loan...
A person planned to start a business venture in Muscat and decided to borrow a loan of OMR 52000 from Bank Muscat at an interest rate of 18 % per annum. Determine the following a) Simple interest and total amount due after 12 years if no intermediate payments are made and interest is compounded annually. b) Compound interest and total amount due after 9years if no intermediate payments are made and interest is compounded annually. c) Compound interest after 9...
Al Bundy wants to start a shoe store. It will cost $150,000 to get the business...
Al Bundy wants to start a shoe store. It will cost $150,000 to get the business started. Al can borrow the money from a bank at 5.5% interest rate. The estimated net cash flows from the business for the first 6 years are:    -$50,000; -$20,000; $100,000; $180,000; $300,000; $360,000. Al will be happy to earn at least 12% so use a 12% discount rate. Answers questions 21-23. 21. The net present value of this business opportunity is:    a. $327,600               ...
Inputs: Purchase Price = $200,000, Down Payment = $10,000 (5%), Start Interest Rates = 4%, Loan...
Inputs: Purchase Price = $200,000, Down Payment = $10,000 (5%), Start Interest Rates = 4%, Loan Term = 30 years, Monthly Liabilities = $450 (car loan), Under Monthly Housing Expense input Real Estate Taxes + $3,000 annually, Hazard Insurance = $800 annually, Dues or Fees = $0. Click “Calculate”. Click “View Report”. What is the required annual income required for a 4% loan? ___________ What is the required annual income required for a 5% loan? ___________ What is the Private...
AFX Sdn Bhd is trying to decide whether to accept a business loan or a lease...
AFX Sdn Bhd is trying to decide whether to accept a business loan or a lease financing facility for an equipment purchase. The equipment cost $60,000 with 3-year economic life, depreciated annually based on MACRS 3-year class with the following rates: Year 1 = 33%; Year 2 = 45%; Year 3 = 15%; Year 4 = 7%. If AFX accepts the business loan option, the 3-year loan will attract an interest rate at 12% interest calculated on a yearly reducing...
You want to borrow $300,000 to start a business. The loan initial balance is increased by...
You want to borrow $300,000 to start a business. The loan initial balance is increased by 2% of the loans face value(for loans origination fees, mortgage insurance, credit checks, title searches etc) Your annual payments are calculated using an initial balance of $306,00 an interest rate of 9% and a 20 year term. The bank requires you to refinance the loan in 5years by paying it off with a balloon payment. what interest rate are you paying?
In order to start this coffee business, the Manager took a 300K loan from the bank....
In order to start this coffee business, the Manager took a 300K loan from the bank. He/she will have to pay 10K monthly for three years. a-Calculate the effective interest rate (per year). b-If the coffee business makes a Revenue=19K/month and has an operational cost of 12K/Month, Calculate the PW if the study period is 5 years and the MARR is equal to 1.5% per month. Solve by Hand Please
In order to start a coffee business, the Manager took a 300K loan from the bank....
In order to start a coffee business, the Manager took a 300K loan from the bank. He/she will have to pay 10K monthly for three years. a-Calculate the effective interest rate (per year). b-If the coffee business makes a Revenue=19K/month and has an operational cost of 12K/Month, Calculate the PW if the study period is 5 years and the MARR is equal to 1.5% per month. Solve by spreadsheet.
A colleague tells you that he can get a business loan from the bank, but the...
A colleague tells you that he can get a business loan from the bank, but the rates seem very high for what your colleague considers a low risk loan. Give an adverse selection explanation for this, and offer advice to your friend on how to solve the problem. Give a moral hazard explanation for this, and offer advice to your friend on how to solve the problem.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT