Question

In: Finance

In January 2018 Ms Langa took a loan of R250 000 that matures in December 2033....

In January 2018 Ms Langa took a loan of R250 000 that matures in December 2033. The bank charges an interest rate of 24% and requires her to repay in equal semi-annual instalments over the period.

b. What is the number of repayments expected to complete the schedule?

side note

a. repayment amount R31 036

Solutions

Expert Solution

Number of repaymentd = years*payment per year = (2033-2018)*2 = 30

Semi Annual rate(M)= yearly rate/12= 12.00% Semi Annual payment= 31035.91
Half year Beginning balance (A) Semi Annual payment Interest = M*A Principal paid Ending balance
1 250000.00 31035.91 30000.00 1035.91 248964.09
2 248964.09 31035.91 29875.69 1160.22 247803.86
3 247803.86 31035.91 29736.46 1299.45 246504.41
4 246504.41 31035.91 29580.53 1455.39 245049.03
5 245049.03 31035.91 29405.88 1630.03 243418.99
6 243418.99 31035.91 29210.28 1825.64 241593.36
7 241593.36 31035.91 28991.20 2044.71 239548.65
8 239548.65 31035.91 28745.84 2290.08 237258.57
9 237258.57 31035.91 28471.03 2564.89 234693.69
10 234693.69 31035.91 28163.24 2872.67 231821.01
11 231821.01 31035.91 27818.52 3217.39 228603.62
12 228603.62 31035.91 27432.43 3603.48 225000.14
13 225000.14 31035.91 27000.02 4035.90 220964.24
14 220964.24 31035.91 26515.71 4520.21 216444.04
15 216444.04 31035.91 25973.28 5062.63 211381.41
16 211381.41 31035.91 25365.77 5670.15 205711.26
17 205711.26 31035.91 24685.35 6350.56 199360.70
18 199360.70 31035.91 23923.28 7112.63 192248.07
19 192248.07 31035.91 23069.77 7966.15 184281.92
20 184281.92 31035.91 22113.83 8922.08 175359.84
21 175359.84 31035.91 21043.18 9992.73 165367.10
22 165367.10 31035.91 19844.05 11191.86 154175.24
23 154175.24 31035.91 18501.03 12534.89 141640.36
24 141640.36 31035.91 16996.84 14039.07 127601.29
25 127601.29 31035.91 15312.15 15723.76 111877.53
26 111877.53 31035.91 13425.30 17610.61 94266.91
27 94266.91 31035.91 11312.03 19723.88 74543.03
28 74543.03 31035.91 8945.16 22090.75 52452.28
29 52452.28 31035.91 6294.27 24741.64 27710.64
30 27710.64 31035.91 3325.28 27710.64 0.00
Where
Interest paid = Beginning balance * Semi Annual interest rate
Principal = Semi Annual payment – interest paid
Ending balance = beginning balance – principal paid
Beginning balance = previous Half year ending balance

Related Solutions

Suppose that on January ?6, 2018?, Westfall Motors paid $ 450 comma 000 comma 000 for...
Suppose that on January ?6, 2018?, Westfall Motors paid $ 450 comma 000 comma 000 for its 30 % investment in Power Motors. Westfall has significant influence over Power after the purchase. Assume Power earned net income of $ 50 comma 000 comma 000 and paid cash dividends of $ 15 comma 000 comma 000 to all outstanding stockholders during 2018. ?(Assume all outstanding stock is voting? stock.) Read the requirements LOADING.... Requirement 1. What method should Westfall Motors use...
Sales Forecasts for the first quarter of 2018: January 11 000 units February 13 000 units...
Sales Forecasts for the first quarter of 2018: January 11 000 units February 13 000 units March 14 000 units. Unit selling price $100 Prepare the Sales Budget for Jan, Feb, and March. In addition to the info in problem #1, the company requires jan 20% of next month's budgeted sales as ending finished goods feb inventory each month. Ending inventory for 12/31/17 was mar 2,200 units. The Sales forecast for April is 20,000 units.
A machine was purchased on 2 January 2018 for $70 000, net of GST. The machine...
A machine was purchased on 2 January 2018 for $70 000, net of GST. The machine had an estimated residual value of $12 000 and an estimated useful life of 6 years. Using the sum-of-the-years'-digits method and rounding to the nearest dollar, depreciation expense for the year ended 31 December 2019, is: $13 810. $16 667. $16 571. $20 000. If a computer with a fully depreciated cost of $10 000 is discarded as worthless, the correct accounting entry to...
At December 31​, 2018​, the Accounts Receivable balance of GPC Technology is $ 225 comma 000....
At December 31​, 2018​, the Accounts Receivable balance of GPC Technology is $ 225 comma 000. The Allowance for Bad Debts account has a $ 17 comma 060 debit balance. GPC Technology prepares the following aging schedule for its accounts​ receivable: LOADING...​(Click the icon to view the aging​ schedule.) Read the requirementsLOADING.... Requirement 1. Journalize the​ year-end adjusting entry for bad debts on the basis of the aging schedule. Show the​ T-account for the Allowance for Bad Debts at December...
LOAN AMORTIZATION Jan sold her house on December 31 and took a $25,000 mortgage as part...
LOAN AMORTIZATION Jan sold her house on December 31 and took a $25,000 mortgage as part of the payment. The 10-year mortgage has a 9% nominal interest rate, but it calls for semiannual payments beginning next June 30. Next year Jan must report on Schedule B of her IRS Form 1040 the amount of interest that was included in the two payments she received during the year. a. What is the dollar amount of each payment Jan receives? Round your...
LOAN AMORTIZATION Jan sold her house on December 31 and took a $30,000 mortgage as part...
LOAN AMORTIZATION Jan sold her house on December 31 and took a $30,000 mortgage as part of the payment. The 10-year mortgage has a 12% nominal interest rate, but it calls for semiannual payments beginning next June 30. Next year Jan must report on Schedule B of her IRS Form 1040 the amount of interest that was included in the two payments she received during the year. 1. What is the dollar amount of each payment Jan receives? Round your...
1] On 1 January 2018 Panorama Ltd acquired equipment for $22 000, net of GST. The...
1] On 1 January 2018 Panorama Ltd acquired equipment for $22 000, net of GST. The estimated residual value for the equipment is zero. Depreciation is calculated at 10% p.a) on the diminishing-balance basis. The depreciation expense for the year ended 31 December 2020 is: a $1604. b $1782. c $1980. d $2200. 2] The correct entry to record the purchase of a motor vehicle for $40 000 cash, plus 10% GST is which of the following? a DR Motor...
Lowlife Company defaulted on a $190,000 loan that was due on December 31, 2018. The bank...
Lowlife Company defaulted on a $190,000 loan that was due on December 31, 2018. The bank has agreed to allow Lowlife to repay the $190,000 by making a series of equal annual payments beginning on December 31, 2019. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Required: 1. Calculate the required annual payment if the bank’s interest rate is 10% and four...
The following inventory transactions took place near December 31, 2018, the end of the Rasul Company's...
The following inventory transactions took place near December 31, 2018, the end of the Rasul Company's fiscal year-end: On December 27, 2018, merchandise costing $2,000 was shipped to the Myers Company on consignment. The shipment arrived at Myers's location on December 29, but none of the merchandise was sold by the end of the year. The merchandise was not included in the 2018 ending inventory. On January 5, 2019, merchandise costing $8,000 was received from a supplier and recorded as...
On January 1st 2018, the Antman Company was founded when Ms. Wasp purchased 100 units of...
On January 1st 2018, the Antman Company was founded when Ms. Wasp purchased 100 units of inventory at $25 each On February 1st Antman sold 80 units of inventory at $40 each On March 1st Antman purchased 200 units of inventory at $27 each On July 1st Antman purchased 300 units of inventory at $30 each On August 1st Antman sold 400 units of inventory at $44 each On October 1st Antman purchased 300 units of inventory at $31 each...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT