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
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
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.





