(b) The company is considering purchasing a new delivery truck for$1,200,000. The intention is to obtain a 5-year loan from theirbank, at an interest rate of 9% per annum. Annual payments areexpected to be made on the loan.Required:i. Calculate DEVCON Industries' annual payment on this loan.ii. Prepare the 5-year Amortization Schedule for this loan,clearly showing the interest and principal paymentannually. DEVCON INDUSTRIES LIMITEDIncome StatementFor the years ended Dec. 31, 2018 and201920182019so00'ss000'sSales9000001125000Cost of Goods Sold300000306600Gross Profit600000818400Selling and Administrative Expenses150000156000Depreciation Expense5400057000Advertising Expenses1800021000Earnings Before Interest and Taxes378000584400Interest Expense30003000Taxable Income375000581400Taxation (35%)131250203490Net Income243750377910Dividends (40%)97500151164Addition to Retained Earnings146250226746Additional InformationShare Price2127.3Ordinary Shares Outstanding120000000144000000DEVCON INDUSTRIESLIMITEDStatement of FinancialPositionAs at Dec. 31, 2018 and 2019ASSETS20182019LIABILITIES & EQUITY20182019Current Assetss00'ss000'sCurrent Liabilitiesso00'sSo00'sInventories264000276000Accounts PayablesNotes Payables138000114000Accounts Receivables294000330000150900132654Cash and Equivalents210900270000288900246654768900876000Non-current Liabilities12000090000Total Liabilities408900336654Net Fixed Assets630600690000EquityCommon Stock264000276000Retained Earnings726600953346Total Equity9906001229346Total Assets13995001566000Total Liabilities & Equity13995001566000

Present value of all loan repayments will be equal to the principal of loan. When a loan is repaid…

(b) The company is considering purchasing a new delivery truck for $1,200,000. The intention is to obtain a 5-year loan from their bank, at an interest rate of 9% per annum. Annual payments are expected to be made on the loan. Required: i. Calculate DEVCON Industries' annual payment on this loan. ii. Prepare the 5-year Amortization Schedule for this loan, clearly showing the interest and principal payment annually.

(b) The company is considering purchasing a new delivery truck for $1,200,000. The intention is to obtain a 5-year loan from their bank, at an interest rate of 9% per annum. Annual payments are expected to be made on the loan. Required: i. Calculate DEVCON Industries' annual payment on this loan. ii. Prepare the 5-year Amortization Schedule for this loan, clearly showing the interest and principal payment annually.

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

A $700,000 loan was received on Nov. 30, 2022, with annual interest at 9.5%, C/M, requires monthly, end of period payments of $7,700, beginning Dec.31, 2022. How many payments are needed to fully pay off the loan? How much will the final payment be? How much interest is paid on the 30th payment? What is the balance still owing after 10 years? How much of the loan principal will be paid, in total, during years 6 and 7? How much interest is paid, in total, during the life of the loan?
1
The Odessa Supply Company is considering obtaining a loan from a sales finance company secured by inventories under a field warehousing arrangement. Odessa would be permitted to borrow up to $350,000 under such an arrangement at an annual interest rate of 10 percent. The additional cost of maintaining a field warehouse is $17,000 per year. Assume that there are 365 days per year. Determine the annual financing cost of a loan under this arrangement if Odessa borrows the following amounts: $350,000. Round your answer to two decimal places. % $320,000. Round your answer to two decimal places. %
A manufacturer needs to borrow money to purchase a building. The purchase price of thebuilding is $1.5 million, and the company will put $300,000 in cash down at closing. If thecompany can borrow the difference from its bank at 4.85% for 20 years, what will the monthlyprincipal and interest payment of the loan be? Create an amortization schedule also. Solved in excel
Ace Development Company is trying to structure a loan with the First National Bank. Ace would like to purchase a property for $3.25 million. The property is projected to produce a first year NOI of $125,000. The lender will allow only up to an 80 percent loan on the property and requires a DCR in the first year of at least 1.25. All loan payments are to be made monthly but will increase by 3.5 percent at the beginning of each year for five years. The contract rate of interest on the loan is 5.5 percent. The lender is willing to allow the loan to negatively amortize; however, the loan will mature at the end of the five-year period. Excel calculation would be appreciated! a. What will the balloon payment be at the end of the fifth year? b. If the property value does not change, what will the loan-to-value ratio be at the end of the five-year period?
Company A is contemplating on borrowing $500,000 to start a business. Credit union 1 has offered to loan the company the money at an interest rate of 14% compounded continuously. Credit union 2 has offered the money with the stipulation that the company repays it by making monthly payments of $120,000 for 5 years. From which credit union should the company borrow the money?
A property is expected to have NOI of $100,000 the first year. The NOI is expected to increase by 5 percent per year thereafter. The appraised value of the property is currently $1.25 million and the lender is willing to make a $1,125,000 participation loan with a contract interest rate of 5.5 percent. The loan will be amortized with monthly payments over a 20-year term. In addition to the regular mortgage payments, the lender will receive 50 percent of the NOI in excess of $100,000 each year until the loan is repaid. The lender also will receive 50 percent of any increase in the value of the property. The loan includes a substantial prepayment penalty for repayment before year 5, and the balance of the loan is due in year 10. (If the property has not been sold, the participation will be based on the appraised value of the property.) Assume that the appraiser would estimate the value in year 10 by dividing the NOI for year 11 by an 8 percent capitalization rate. Assume that another…
(Loan Amortization Problem) Your company is planning to borrow $2,500,000. This will be a six-year, 2 percent per year, annual payment, fully amortized term loan. The first payment will be made one year from today. What fraction of the total annual payment made at the end of year three will represent repayment of principal? [Hint: you need only complete the first three rows of the amortization schedule to answer this question.] Step By Step please, as if writing down the solution on a sheet of paper.
using excel do the following Create an amoritization schedule for a $1,000,000 loan that requires equal annual payments in each of the next 10 years. The annual rate is 6%. How much is the remaining loan balance after 5 years? Analyze the amount of each equal payment that goes towards interest and principal in each year. What do you notice?
AllBets Corporation is building a $25 million office building in Las Vegas and is financing the construction at an 80 percent loan-to-value ratio, where the loan is in the amount of $20 million. The loan has a ten-year maturity, calls for monthly payments, and has a fixed interest rate of 8 percent. Using the above information, create a full amortization table, and then answer the following questions: 1) What is the monthly payment? 2) How much of the first payment goes toward interest? 3) How much of the first payment goes toward principal? 4) How much will AllBets Corporation owe on this loan after making monthly payments for three years (the amount owed immediately after the thirty-sixth payment)? 5) If AllBets can add $5 million to its 20th payment, should they? Why or why not?
Consider a project with an initial investment of $300,000, which must befinanced at an interest rate of l2% per year. Assuming that the required repayment period is six years, determine the repayment schedule by identifying the principal as well as the interest payments for each of the following repayment methods:(a) Equal repayment of the principal: $50,000 principal payment each year(b) Equal repayment of the interest: $36,000 interest payment each year(c) Equal annual installments: $72,968 each year
A local finance company quotes a 17 percent interest rate on one-year loans. So, if you borrow $30,000, the interest for the year will be $5,100. Because you must repay a total of $35,100 in one year, the finance company requires you to pay $35,100/12, or $2,925.00, per month over the next 12 months. a. What rate would legally have to be quoted? b. What is the effective annual rate?

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS