Question

In: Finance

He borrows $1.5 million from ABC Bank to start this business. The bank charged him an...

He borrows $1.5 million from ABC Bank to start this business. The bank charged him an add-on rate 0.16% per month and the repayment period is 4 year. How much he has to repay every month?

Solutions

Expert Solution

Monthly payment = [P × R × (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P $                                                       1,500,000
Rate of interest per period:
Annual rate of interest 1.920%
Frequency of payment = Once in 1 month period
Numer of payments in a year = 12/1 = 12
Rate of interest per period R 0.0192 /12 = 0.1600%
Total number of payments:
Frequency of payment = Once in 1 month period
Number of years of loan repayment =                                                                          4
Total number of payments N 4 × 12 = 48
Period payment using the formula = [ 1500000 × 0.0016 × (1+0.0016)^48] / [(1+0.0016 ^48 -1]
Monthly payment = $                                                      32,490.34

Monthly payment is $32,490.34

please rate.


Related Solutions

Manufacturing company borrows 4 million euros from the bank to fight the consequences of the corona...
Manufacturing company borrows 4 million euros from the bank to fight the consequences of the corona virus. The repayment schedule is based on an annuity. The interest rate is 8% and the loan is paid back with 4 annual payments. Question: * What is the loan balance immediately the first loan payment is made? (Please present your answers by rounding up to thousands and use thousands as unit of measurement. For example the answer 250920 should be written as 251)
Manufacturing company borrows 5 million euros from the bank to fight the consequences of the corona...
Manufacturing company borrows 5 million euros from the bank to fight the consequences of the corona virus. The repayment schedule is based on an annuity. The interest rate is 10% and the loan is paid back with 6 annual payments. Question: * What is the loan balance immediately the first loan payment is made?
On September 30, ABC Company borrows $120,000 from Ottawa State Bank by signing a 6-month, 7.25%,...
On September 30, ABC Company borrows $120,000 from Ottawa State Bank by signing a 6-month, 7.25%, interest-bearing note. Instructions: Prepare the necessary entries below associated with the note payable on the books of ABC Company. (a)    Prepare the journal entry when the note was issued.                                            (b)    Prepare the adjusting entry at December 31 to accrue interest.                           (c)    Prepare the entry to record payment of the note at maturity date.    Solution question 2: Date Account title and explanation Debit...
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.
Oliver borrows $300,000 from a bank and agrees to repay the bank with equal payments at...
Oliver borrows $300,000 from a bank and agrees to repay the bank with equal payments at the end of each year for 30 years based on an annual effective interest rate of 5%. After making the 10th payment, the bank allows Oliver to make no payments for 10 years, with increased level payments after that. At the end of the 30-year period, the loan is fully paid. How much does Oliver pay each year when he resumes payment? Possible answers...
James Walker owns Walker Auto Sales. He periodically borrows money from New Orleans State Bank and...
James Walker owns Walker Auto Sales. He periodically borrows money from New Orleans State Bank and Trust. He permits some customers to sign short-term notes for their purchases. He usually discounts these notes at the bank. Following are selected transactions that occurred in March 2019. DATE TRANSACTIONS 2019 Mar. 4 Mr. Walker borrows $10,000 from the bank on a note payable for the business. Terms of the note are 8 percent interest for 45 days. 11 A 90-day $9,000 note...
In order to purchase manufacturing equipment, a company borrows $1,118,000 from a bank. The bank charges...
In order to purchase manufacturing equipment, a company borrows $1,118,000 from a bank. The bank charges an interest rate of 3.00% per year, compounded annually. After 3 years the company repays the bank in one single payment. a) How much money is the company required to pay the bank? b) How much of the money the company pays the bank is due to interest charges?
A friend proposes to him to invest in a business for which he has projected the...
A friend proposes to him to invest in a business for which he has projected the following costs and income: 1. Initial cost of $ 100 0002. Expenditure in year 1 of $ 50 0003. Annual expenses from year 2 to 10 of $ 10 000. Additionally he projects that from In year 4, these expenses will increase by $ 2,000 each year. 4. Annual income of $ 40,000 from year 1 to 10. Additionally, it projects that from year...
Jake borrows $35,000 to finance the expansion of his business. He promises to repay with the...
Jake borrows $35,000 to finance the expansion of his business. He promises to repay with the entire amount plus interst in exactly 5 years. The annual interest rate is 7.5%. What is the amount of Jake's monthly payments? Please answer using excel formulas & show your work. Thanks.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT