I have answered the first question and created the cash flow statement. Help with question 2 and 3 please

2. Compute and comment on PPPs 2020 financial ratios relevant to Jamies decisions.

3. Without preparing financial forecasts, comment on how Jamies three ideas are likely to affect profitability, liquidity, and efficiency (asset utilization). State all assumptions clearly.

A study commissioned by Federal Express Canada Corporation (FedEx) that surveyed 1,500 Canadians in September of 2019 found that one in four of those surveyed had had a package stolen and that 70 percent of respondents who shop online worry about package theft!. Porch pirates steal packages left on front porches when the person ordering the goods is not at home. In 2016, Jamie Foil, an experienced pipeline welder, formed Porch Pirate Protection, Inc. (PPP), a fictitious company headquartered in Guelph, Ontario?. PPP sells high quality, welded aluminum boxes designed to thwart porch pirates. While not meteoric, sales have increased steadily each year and in 2020 PPP sold 5,000 units. Jamie wants to continue to grow the business to increase PPP's profitability and to contribute to the local economy. However, the industry is becoming very competitive, and profit margins are getting squeezed. Jamie had been investigating three ideas PPP for 2021. First, by purchasing a forklift and steel shelving, PPP could double the amount of inventory that could be warehoused in PPP's rented location leased for $3,000 per month. This change would address a problem that occurred several times a year when the local metal fabricator was busy with other customers and could not deliver boxes on time to PPP. Purchasing the forklift and steel shelving would cost approximately $30,000 and would be an alternative to using a supplier other than the one local metal fabricator that PPP has always used. Second, Jamie had talked with a local sign company and its metal fabricator about improving the signage and weatherproofing. While this would increase the cost of the boxes by about 10 percent, it would decrease complaints from customers about rain dripping into the boxes and delivery company drivers failing to use the box and leaving packages on the porch. Finally, Jamie is thinking about introducing a second model of the box, the See You smart model, that would include a motion-sensitive night-vision camera and notify the box owner of deliveries. While this would require that the box be installed with access to power and wifi, Jamie saw that smart boxes sold by competitors were listed for double the current $225 price of his model. How much could a webcam cost? Jamie had seen them online for less than $50. Diversification and upgrading are difficult because they require capital. If the business does not generate enough cash to fund the changes it is problematic. Jamie is the sole shareholder of Porch Pirate Protection. Jamie had taken an accounting course and wondered if it would be better to borrow more money from friends and family (his only source of long- term financing), borrow more money from the local bank, or sell shares on the Toronto Stock Exchange (TSX). Jamie had visited PPP's bank for initial discussions about an increase in the bank loan. He learned that any increase in the loan would not only require a personal guarantee but would also include covenants, such as a stipulation that the Current Ratio could not fall below 1:1 and that PPP have positive cash flow. Furthermore, Jamie discovered that the bank would require a landlord waiver that the landlord gives up his right of distraint in the event of non-payment of rent or violation of the lease. Jamie had also found the TSX Guide to Listing" online but had not checked out the listing requirements yet. Jamie is not sure where to begin. You took an introductory financial accounting course with Jamie. When Jamie heard that you are now taking a course in financial management, Jamie has asked for your help. Required: 1. Prepare a cash flow statement for 2020. The appendix includes the income statements for the years ending December 31, 2020 and 2019 and the balance sheets for 2019 and 2020. Equipment has not been sold in the past five years. Porch Pirate repaid $5,000 of long-term debt in 2020 and 2019. 2. Compute and comment on PPP's 2020 financial ratios relevant to Jamie's decisions. 3. Without preparing financial forecasts, comment on how Jamie's three ideas are likely to affect profitability, liquidity, and efficiency (asset utilization). State all assumptions clearly. 4. Recommend the "best" option for financing. 5. List other factors that may also impact Jamie's decision. APPENDIX PORCH PIRATE PROTECTION Income Statements for Years Ended December 31, 2020 2019 Sales (all are credit sales) Cost of goods sold Gross profit Selling and administration expense Amortization Operating profit Interest expense Earnings before taxes Taxes Earnings available to common shareholder $ 1,125,000 720,000 405,000 283,500 14,000 107,500 65,100 42,400 10,600 $ 31,800 $ 987,000 621,810 365,190 237,374 14,400 113,417 50,550 62,867 15,717 $ 47,150 Dividends declared and paid $ $ 40,000 PORCH PIRATE PROTECTION Balance Sheet December 31, 2020 2019 Assets $ $ Cash Accounts receivable Inventory Prepaid expenses Total current assets Net plant and equipment Total assets 14,650 550,000 180,000 12,000 756,650 80,000 836,650 2,574 375,060 143,016 14,000 534,650 89,000 623,650 $ $ $ Liabilities and Shareholder's Equity Accounts payable Bank loan Accrued expenses Total current liabilities Long-term debt Total liabilities Common stock Retained Earnings Total shareholder's equity Total liabilities and shareholder's equity 299,000 295,000 23,700 617,700 115,000 732,700 40,000 63,950 103,950 836,650 $ 219,500 221,000 17,000 457,500 120,000 577,500 14,000 32,150 46,150 $ 623,650 $ PORCH PIRATE PROTECTION INC Statement of Cash Flows For Year Ended December 31, 2020 $ 14,000 31,800 14,000 45,800 (174,940) (36,984) 2,000 79,500 74,000 6,700 Operating Activities Net income (earnings after taxes) Amortization Cash flow from operations Increase in accounts receivable Increase in inventory Decrease in prepaid expenses Increase in accounts payable Increase in bank loan Increase in accrued expenses Net changes in noncash working capital Cash used in operating activites Investing Activities Purchase of plant and equipment Cash used by investing activities Financing Activities Repayment of long-term debt Proceeds from issuance of common stock Cash provided by financing activities Net increase (decrease) in cash during the year 2020 Cash, beginning of year 2020 Cash, end of year 2020 (49,724) (3,924) $ (5,000) (5,000) (5,000) $ (5,000) 26,000 21,000 12,076 2,574 14,650 $