Using the data presented below. 2019 $398,600 315,300 SUC Berhad Income Statements For the Years 2019 and 2020 20.20 Sales $412,500 Cost of Goods 318,786 Gross Profit Depreciation 29,800 Selling & Admin. Expense 26,250 Other Operating Expense 1,210 Net Operating Income Interest Expense 8,582 Earnings Before Tares Taxes Net Income Notes: Tax Rate 25.00% Shares 52,100 Earnings per Share 30.40 29,652 24,550 1,245 8,457 25.00% 52,100 $0:28 This question paper consists of4iquestions on printed pages 4 BBEN3433 FINANCIAL MODELING Q3. (Continued) SUC Berhad Balance Sheet For the Year Ended December 31, 2020 2020 2019 $16,435 3,656 45,896 52,397 $11,596 619 47,404 54,599 436,573 87.450 397,023 57,650 Assets Cash Marketable Securities Accounts Receivable Inventory Total Cwment Assets Gross Fixed Assets Accumulated Depreciation Net Plant & Equipment Total Assets Liabilities & Owner's Equity Accounts Payable Accrued Expenses Total Current Liabilities Long-term Debt Total Liabilities Common Stock ($1.00 par) Additional Paid-in-Capital Retained Earnings Owner's Equity Total Liabilities & Owner's Equin $37.752 3.183 $36,819 3,085 170,562 173.581 58,664 58,664 136,807 136,807 60.539 39,635 Total a ) (b) Recreate the income statement and balance sheet using formulas wherever possible. Try to duplicate the formatting exactly. (8 marks) Create a statement of cash flows for 2020. Do not enter any numbers directly on this worksheet. All formulas should be linked directly to the source on previous tables from part (a). (1 marks) Suppose that sales were $425,000 in 2020 rather than $412,500, calculate the net profit margin for 2020. (4 marks) Undo the changes from part (c), and change the tax rate to 20%, calculate the net profit margin for 2020. What is the effect of tax rate on net profit margin? (6 marks) [Total 25 marks) o