FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Make an excel spread sheet showing the calculations. A $22,820 loan is to be settled by making payments of $6,813 at the end of every

image text in transcribedMake an excel spread sheet showing the calculations.

A $22,820 loan is to be settled by making payments of $6,813 at the end of every three months. The interest is 6.19% compounded quarterly. a) Find the number of payments in the term (Round off to two decimal places). b) Fill in the missing values of the amortization schedule below. Round off your answers to two decimal places

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistics For Economics Accounting And Business Studies

Statistics For Economics Accounting And Business Studies

Authors: Michael Barrow

7th Edition

1292118709, 978-1292118703

More Books

Students also viewed these Accounting questions

Question

★★★★★
In a production facility, 1.5-in-thick, 1-ft Ã3 square brass plates (Ï = 5 532.5 lbm/ft3 and cp = 0.091 Btu/lbm·°F) that are initially at a uniform temperature of 75°F are...

Answered: 1 week ago

Question

★★★★★
=+LG 2 P517 Cash flow investment decision Tom Alexander has an opportunity to purchase any of the investments shown in the following table. The purchase price, the amount of the single cash inflow,...

Answered: 1 week ago

Question

★★★★★
Find the investors expected profit.

Answered: 1 week ago

Question

★★★★★
Two loudspeakers, A and B (Fig. 16.40), are driven by the same amplifier and emit sinusoidal waves in phase. Speaker B is 2.00 m to the right of speaker A. The frequency of the sound waves produced...

Answered: 1 week ago

Question

★★★★★
Primus, Inc., owns all outstanding stock of Sonston, Inc. For the current year, Primus reports net Income (exclusive of any Investment Income) of $488,000. Primus has 50,000 shares of common stock...

Answered: 1 week ago

Question

★★★★★
When the yield curve is upward -sloping, then: A) long-maturity bonds increse in price when interest rates increase B) short-maturity bonds offer the highest coupon rates C) short-maturity bonds...

Answered: 1 week ago

Question

★★★★★
Control: On a monthly basis, each component controller performs a comparison of operating results to budget amounts for their respective component. Variances in excess of US$25,000 are investigated....

Answered: 1 week ago

Question

★★★★★
12. Prepare a Double Column Cash Book from the following with Cash & Bank Column. 2022 Jan. 1 Jan. 4 Balance in hand 6,000 and overdraft at Bank 7,000 Received a cheque from Avinash and Co. for goods...

Answered: 1 week ago

Question

★★★★★
A dog training business began on December 1. The following transactions occurred during its first month. December 1 Receives $33,000 cash as an owner investment in exchange for common stock. December...

Answered: 1 week ago

Question

★★★★★
15) If Cost of Goods Sold is $250,000, beginning inventory is $29,000, and ending inventory is $36,000, then the purchases from suppliers (assume all on account) would be: A) $257,000. B) $315,000....

Answered: 1 week ago

Question

★★★★★
Some schools of thought distinguish between the decision process (that is, the techniques and methods used to make decisions) and the decision outcome. Discuss why this distinction is important and...

Answered: 1 week ago

Question

★★★★★
1 Should companies adopt diversity policies because they are the right thing to do or because they can be used to enhance the companys reputation on performance? Brazil recently surpassed the UK to...

Answered: 1 week ago

Question

★★★★★
1 If you were a senior trade union representative in an organisation where traditional leadership was the norm, how might you react to the idea of decentralisation and lateral leadership? A powerful...

Answered: 1 week ago

Question

★★★★★
1 What impact is leadership style likely to have on communication and employee participation? A few years ago the results of a survey of 200 chief executives, chairmen and directors of companies in...

Answered: 1 week ago

Previous Question Next Question