Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

1

Accounting Dec 04, 2020

1. If you plan to purchase a home and your bank is ready to offer you a $200,000 mortgage loan for 10 years. The loan bears a compound annual interest rate of 24 percent (6% per quarter) and calls for equal quarterly installment payments at the end of each quarter for the next 10 years. a) What is the amount of the quarterly payment that you have to pay the bank? (6 points) b) Establish loan amortization schedules for the first 4 quarters only? (8 points) c) What is the total amount that will be paid at the end of 10th year? (3 points) d) What is the amount of total interest that will be paid after 10 years? (3 points) 2. The following data relates to Stylo Corp. during 2019-20; Accounts payable: Accounts receivable: Inventory: Total sales Credit sales: Cost of goods sold: Beginning Balance $110,000 $290,000 $ 85,000 $600,000 75% of total sales 60% of total sales Ending Balance $180,000 $270,000 $ 95,000 Industry average for Days Inventory Outstanding (DIO) is 95 days, whereas Credit term offered by

Expert Solution

1.

a) Eqaul quarterly payment = $13,292.31 (calculated using pmt function in excel)

b)Loan amortisation schedule

End of quarter Opening Balance Installment Principal Interest Closing
0 $200,000 $13,292.31 $1,292.31 12000 $198,707.69
1 $198,707.69 $13,292.31 $1,369.85 11922.5 $197,337.85
2 $197,337.85 $13,292.31 $1,452.04 11840.3 $195,885.81
3 $195,885.81 $13,292.31 $1,539.16 11753.1 $194,346.65
4 $194,346.65 $13,292.31 $1,631.51 11660.8 $192,715.14

c)Total Amount

Total cumulative amount that will be paid at end of 10 years= 10*4*$13,292.31 = $531,692.29

Installment at end of 10th year = $13,292.31

d) Amount of interest (cumulative) that will be paid after 10 years = $531,692.29 - $200,000

= $331,692.29

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment