Solution-Case - Preparation of Bond and Loan Amortization

Case - Preparation of Bond and Loan Amortization Tables

Assignment Help Managerial Accounting

Reference no: EM133109831

Excel Case - Preparation of Bond and Loan Amortization Tables -

Part 1 - A) Prepare a Premium Bond Amortization Table based on the following Given information:

Soda Corporation issued a 4.0%, 30-year bond, dated January 1, 2022 with a face value of $5 million on January 1, 2022. The market yield for bonds of similar risk and maturity was 3.8%. Interest is paid to investors semiannually on June 30 and December 31.

B) Prepare a Discount Bond Amortization Table with the following Given information:

Forma Corporation issued a 4.1%, 25-year bond, dated January 1, 2022 with a face value of $7 million on January 1, 2022. The market yield for bonds of similar risk and maturity was 4.15%. Interest is paid to investors semiannually on June 30 and December 31.

Part 2 - Prepare an Installment Loan (Note) Amortization Table based on the following Given information:

Small Motors Company obtained a 4-year loan from its bank in the amount of $225,000. The loan was dated October 1, 2021 and terms of the loan require Small Motors Company to make monthly payments on the last day of each month beginning October 31, 2021 until the loan is paid in full. The stated annual interest rate for the loan is 4.5%.

Reference no: EM133109831

Questions Cloud

Determining the index value : Three stocks have share prices of $120, $200, and $72 with total market values of $300 million, $530 million, and $350 million, respectively. If you were to con

Methods of investment analysis : Based on the most recent survey information CFOs tend to use which two methods of investment analysis the most frequently?

What is Suncoasts current debt ratio : Question - Suncoast Healthcare is planning to acquire a new X-ray machine that costs $200,000. What is Suncoasts current debt ratio

Capitalization of income approach : How much insurance does Clarke need using the capitalization of income approach for 20 years? $ Hint: Just based on replacing income (PMT) and using the depleti

Case - Preparation of Bond and Loan Amortization Tables : Case - Preparation of Bond and Loan Amortization Tables - The market yield for bonds of similar risk and maturity was 3.8%

Define the importance of purchasing and supply management : Define the importance of purchasing and supply management and how this relates to selecting a qualified supplier.

How much money will be in your account : If you put $20000 in a saving account paying 8% interest compounded monthly how much money will be in your account after 40 year

What is your outstanding balance : After two years of payments, you received a large bonus and you wish to close the loan. What is your outstanding balance

. what challenges confront the organization : Do an initial analysis of the organization's major problems or issues. What challenges confront the organization today-for example,

User Account

All Pages

Case - Preparation of Bond and Loan Amortization Tables

Reference no: EM133109831

Reference no: EM133109831

Questions Cloud

Reviews

Write a Review

Managerial Accounting Questions & Answers

Manage budgets and financial plans

Prepare a retained earnings statement

Prepare a master budget for the three-month period

Construct the companys direct labor budget

Evaluate the predetermined overhead rate

Determine the company''s bid

Compute the pool rates for the different activities

Prepare Company financial statements

Prepare an analysis of terracycles

Discuss the ethical issues

Political resources in emerging markets

Management accounting - ehsan electronics company

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT