Question: How do I create an amortization schedule for a company that borrows 2 million dollars from a bank with equal payments of 776,067 over 3

How do I create an amortization schedule for a company that borrows 2 million dollars from a bank with equal payments of 776,067 over 3 years. Payments are due 31 Dec of each year with an interest rate of 8%.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

QUESTION 32 - LOAN AMORTIZATION (20 MARKS) Time left 2:24:28 Jonathan wishes to borrow $180 000 from a commercial bank. He was told that the loan would be amortized over five years and that payment...

I've attached the question as a word file, thanks! JWCL165_c10_444-505.qxd 8/12/09 7:24 AM Page 444 10 Liabilities Chapter STUDY OBJECTIVES After studying this chapter, you should be able to: 1...

Requirea information [The following information applies to the questions displayed below.] On January 1, 2024, Rosemont Corporation borrowed $5 million from a local bank to construct a new building...

3 Required information [The following information applies to the questions displayed below.] On January 1, 2024, Rosemont Corporation borrowed $8 million from a local bank to construct a new building...

Required information The fovowing information applies to the questions displayed below] On January 1, 2024, Evanston Corporation borrowed $13 milion from a local bank to construct a new building over...

On January 1, 2024, Cicero Corporation borrowed $6 million from a local bank to construct a new building over the next three years. The loan will be paid back in three equal installments of...

Required information (The following information applies to the questions displayed below.] On January 1, 2024, Cicero Corporation borrowed $21 million from a local bank to construct a new building...

THE COMPANY: Aylmer Industries Inc. (Aylmer) has been in business since 2017. Since Aylmer is a publicly traded company, it follows IFRS. Aylmer posted accounting transactions throughout the year....

can you help with questions 41-80? I have attached the document again for reference. 1. The form of organization for a business is not an important issue, as this decision has very little effect on...

On October 1, 2020, Mertag Company (a U.S.-based company) receives an order from a customer in Poland to deliver goods on January 31, 2021, for a price of 1,038,000 Polish zlotys (PLN). Mertag enters...

The mast is subjected to the three forces shown. Determine the coordinate direction angles ? 1 , ? 1 , ? 1 of F 1 so that the resultant force acting on the mast is zero. Fy= 300 N 1F 200 N

Part A [ 7 points ] : If the minimum - variance hedge ratio is calculated as 1 . 0 , the hedge must be perfect. Is this statement true or false? Explain. Part B [ 7 points ] : If there is no basis...

Which project management tool uses the analogy "skateboard - bicycle - motorcycle - car"? Group of answer choices Scrum Waterfall Fate - Gate Star - gate

1.2 Describe the value of HR expertise to non-HR managers and entrepreneurs.

1.5 Describe the core HR competencies and professionalism of the HRM function.

1.6 Discuss the internal and external environmental factors affecting human resources management policies and practices, and explain their impact.