(b) The following are financial statements of Bonzo Trading Company, a retail firm Balance sheet as at Assets Cash Investments Debtors Stocks Building and Equipment (net) 31/12/2019 Kshs 1000s 7,000.00 2,000.00 31/12/2018 Kshs.'000 4,000.00 2] 9,000.00 69,000.00 9,000.00 7,000.00 66,000.00 90.000.00 6,900.00 (4) Liabilities and Capital: Trade creditors 12% % Notes Payable Other Current Liabilities Long term Debt Ordinary Share Capital Profit & Loss A/C 6,000.00 2,800.00 5,200.00 (5) 30,000.00 32,000.00 100.000.00 5,900.00 20,000.00 30,000.00 24.000.00 90.000.00 Income Statement for the Year ended 31/12/2019 Kshs, dos Sales (Cash - Kshs. 35,000.00 100,000.00 Cost of sales 58.000.00 Gross Profit 42,000.00 Selling & Administrative Expenses 16,00.00 Earnings before interest & Taxes (6) Interest Expenses -2,000.00 Profit before tax 24,000.00 Provision for taxation 177 Net Income after tax 16.000.00 Required: Prepare the spreadsheet above and using relevant formulae fill in the colored cells with the correct figures 19 Marks) (c) Adams Limited issued a semi-annual bond with a par value of $ 30,000, coupon rate of Bp.a. and a maturity period of 15 years. Required: Create a model showing the interest and principal repayment separately, and calculate the value of the bond when the required rate of return is 10% if D) Interest is paid annually. 2 Maris) Interest is paid semi-annually, (2 Marks) (i) What would be the value of this bond when the required rate of return is 12% interest paid semi-annually? (1 Mark) (d) using excel model calculate the amount to which $485,000 wil grow at 16% pa. compounded quarterly for the next five (5) years. (2 Maris) Total: 20 Marks