What formula can I use to recreate this table in excel? Table 7.5 Spreadsheet Kappa's Planned Debt and Interest PaymentsYear202120222023202420252026Debt and Interest Table ($ 000)1Outstanding Debt100,000 100,000 100,000 115,000 120,000 120,0002 Interest on Term Loan6.80%(6,800)(6,800)(6,800)(7,820)(8,160)

This table uses a simple interest formula which is given as follows, Interest amount = outstanding…

Answered: Table 7.5 Spreadsheet Kappa's Planned…

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter9: Long-term Liabilities

Section: Chapter Questions

Problem 75E

See similar textbooks

Similar questions

A P1000 000.00 issue of 3%, 15-year bonds is sold at 95%. The miscellaneous initial expense of the financing were P20 000.00 and yearly expenses of P2000.00 is incurred. What is the true cost the company is paying for the money it borrowed? (Ans. 3.8%)
Payment # Payment Interest Debt Payment Balance 1 1,167.34 540.54 626.80 259,873.20 2 1,167.34 539.24 628.10 259,245.10 3 1,167.34 With the exception of column one, all amounts are in dollars. Calculate the annual interest rate on this loan.
QUESTION 16 A Bank lends a Nesta company. R500 000 for one year at 6.48% and requires a compensating balance of 10% of the face value of the loan. The effective annual interest rate associated with the loan is ... 7.00%. 7.20%. 8.00%. 8.90%.
QUESTION 5 The following balance sheet is available for Smith Bank (in millions). Which of the following is true? Assets Potential Potential Amount Liabilities Potential Potential Amount Rate Withdrawal in Rate Withdrawal in Change 6-month millions Change 6-month millions 90-day Treasury Bills 0.50% $25 30-day CDs 0.25% $50 180-day Treasury Bills 0.75% $35 90-day CDs 0.35% $100 1-year Treasury Bills 1.00% $50 Savings Deposits 0.10% $50 1-year consumer loans 1.25% 20% $200 Time-Deposits 180-day 0.60% $200 5-year Consumer loans 1.50% 20% $150 Time Deposits -2 years 1.00% 30% $235 10-year Corporate Loans 1.75% 15% $250 Stockholder's equity $75 Total $710 Total $710 Including potential withdrawals and excluding savings deposits, the six-month earnings at risk is $238,750…
Daisy's LLC borrowed $2.40 million at an APR of 9.0 percent. The loan called for a compensating balance of 18 percent. What is the effective interest rate on the loan? (Round answer to 1 decimal place, e.g. 12.5%.)
7 lender appraised value : $8,400,000 cash flow :$444,000 Using Information Above what would be the loan amount assuming a 75% loan-to-value and a 9% debt yield? Round to nearest dollar.
Question content area top Part 1 Calculate the percentage return on a 1-year Treasury bill with a face value of $10 comma 00010,000 if you pay $9 comma 764.359,764.35 to purchase it and receive its full face value at maturity.
E5.10 (LO 1) At the end of 2020, Montvale Associates borrowed $120,000 from the Bayliner Bank. The debt covenant specified that Montvale’s debt/equity ratio could not exceed 1.5:1 during the period of the loan. A summary of Montvale’s balance sheet after the loan follows. 2020 Assets Current assets $130,000 Long-term assets 350,000 Total assets $480,000 Liabilities and Shareholders’ Equity Current liabilities $130,000 Long-term liabilities 150,000 Shareholders’ equity 200,000 Total liabilities and shareholders’ equity $480,000 Compute Montvale’s debt/equity ratio immediately after the loan. How much additional debt can the company incur without violating the debt covenant?
E5.10 (LO 1) At the end of 2020, Montvale Associates borrowed $120,000 from the Bayliner Bank. The debt covenant specified that Montvale’s debt/equity ratio could not exceed 1.5:1 during the period of the loan. A summary of Montvale’s balance sheet after the loan follows. 2020 Assets Current assets $130,000 Long-term assets 350,000 Total assets $480,000 Liabilities and Shareholders’ Equity Current liabilities $130,000 Long-term liabilities 150,000 Shareholders’ equity 200,000 Total liabilities and shareholders’ equity $480,000 Compute Montvale’s debt/equity ratio immediately after the loan. How much additional debt can the company incur without violating the debt covenant? How large a dividend can the company declare and pay at the end of 2020 without violating the debt covenant?
E5.10 (LO 1) At the end of 2020, Montvale Associates borrowed $120,000 from the Bayliner Bank. The debt covenant specified that Montvale’s debt/equity ratio could not exceed 1.5:1 during the period of the loan. A summary of Montvale’s balance sheet after the loan follows. 2020 Assets Current assets $130,000 Long-term assets 350,000 Total assets $480,000 Liabilities and Shareholders’ Equity Current liabilities $130,000 Long-term liabilities 150,000 Shareholders’ equity 200,000 Total liabilities and shareholders’ equity $480,000 Compute Montvale’s debt/equity ratio immediately after the loan.
Q11 A debt of $15,000 with interest at 12% compounded monthly is repaid over 10 years by equal payments made at the end of every three months. a)the size of the periodic payments b)For the first payment period, how much interest is paid, how much of the principal is repaid, and what is the loan balance? how much interest is paid how much of the principal is repaid what is the loan balance c) For the second payment period, how much interest is paid, how much of the principal is repaid, and what is the loan balance? how much interest is paid how much of the principal is repaid what is the loan balance
Particulars As on 31.3.2019(Rupees. In Lacs)As on 31.3.2020(Rupees. In Lacs)Investment in FinancialAssets- 100Equity Share Capital 150 160Long term Loans taken 100 200Dividend paid - 26Dividend received - 10Interest received - 15 Calculate the debt-equity ratio & comment

SEE MORE QUESTIONS

Recommended textbooks for you

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

Cornerstones of Financial Accounting

Accounting

ISBN:

9781337690881

Author:

Jay Rich, Jeff Jones

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

Table 7.5 Spreadsheet Kappa's Planned Debt and Interest Payments Year 2021 2022 2023 2024 2025 2026 Debt and Interest Table ($ 000) 1 Outstanding Debt 100,000 100,000 100,000 115,000 120,000 120,000 Interest on Term Loan 6.80% (6,800) (6,800) (6,800) (7,820) (8,160)