Please Show All Work and Calculations on Excel Spreadsheet. Dont hand write muzt type . Answers all questions #6-18 because they are all connected as an assignment. Please no skipping steps and questions. Thanks
39 For questions #6-18, refer to the following financial information for Lowery Products: 40 41 2021 2022 42 BALANCE SHEET: 43 Assets: Cash $145,000 $221,800 475,000 472,000 Accounts Receivable Inventory 325,000 410,000 400,000 525,000 Fixed Assets, net Total Assets $1,345,000 $1,628,800 Liabilities and Equity: Accounts Payable $337,000 $377,800 Long-term Debt 525,000 595,000 Common Stock 50,000 70,000 Retained Earnings 433,000 586,000 Total Liabilities and Equity $1,345,000 $1,628,800 FY2022 $3,250,000 2,120,000 605,000 95,000 430,000 40,000 390,000 92,400 $297,600 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 INCOME STATEMENT: 59 Revenue 60 Cost of Goods Sold General and Administrative Depreciation Expense Earnings Before Interest and Taxes Interest Expense Pretax Net Income Income Taxes Net Income 61 62 63 64 65 66 67 68 YOU MUST USE EXCEL FUNCTIONALITY FOR ALL CALCULATIONS TO EARN CREDIT (insert rows where needed): SL 6. What was Lowery's total current assets at the end of 20227 Lowery's total current assets at the end of 2022: 57. What was Lowery's net working capital at the end of 20227 6 7 78 8. What was Lowery's shareholders' equity at book value at the end of 20227 $1 79 80 81 9. An appraiser recently valued Lowery's fixed assets at $480,000 and determined that $35,000 of their accounts receivable was 82 noncollectible. Based on the balance sheet above adjusted for this additional information, what was the market value of Lowery's 83 shareholders' equity at the end of 2022? 84 85 86 10. Assuming that Lowery did not buy back or redeem any of its shares, how much new common stock did it issue in 20227 87 88 89 11. How much dividends did Lowery pay out to its shareholders in 20227 90 91 92 12. What was Lowery's effective annual average tax rate in 20227 93 $2. $25 $92, 400 91 92 12. What was Lowery's effective annual average tax rate in 20227 93 94 95 13. If Lowery had 16,800 shares of common stock outstanding throughout 2022, what was its Earnings per Share (EPS) in 2022? 96 97 98 14. Assuming that Lowery did not dispose of any of its fixed assets, how much new capital spending did it incur in 2022? 99 100 101 15. What was Lowery's Operating Cash Flow (OCF) in 20227 102 103 104 16. What was Lowery's investment in working capital for 2022 (ie. how much did NWC change over the year)? 105 106 107 17. What was Lowery's Cash Flow to Creditors in 2022? 108 109 110 18. What was Lowery's Cash Flow to Stockholders in 20227 111 112 113