LYRIX Panels Inc. (LPI) is a manufacturer of speciality panels, small tools for the panel industry, as well as sales of solar panel, which they build for other manufacturers. The company has been in business since 2015, results include 2020 and 2021. The company through its Board of Directors is developing a plan to acquire more equipment to expand its current facilities. The Board is recommending purchasing $250,000 of new equipment each year and wants to put away cash reserves to purchase the property next to at which has a value of $3,000,000. The CFO who sits on the Board is concerned the Board may have unrealistic goals considering LPI's recent financial performance. The CFO is preparing a report to the Board outlining the concerns. The following is a copy of the income statement: LYRIX Panels Inc. Income Statement (Cash Basis) For the Years Ended June 30 (in thousands) 2021 2020 $ Revenues Speciality Panels Solar Panels Tools for Panel Industry Total Revenues $ 475,000 275,000 4.000 S 754 000 400,000 235,000 2.500 637.500 $ Expenses: Management Wages Plant Wages Plant Supplies Utilties Bank Charges and Interest Miscellaneous Total Expenses S 66,000 225,000 235,000 68,000 45.100 4000 $ 643 100 66,000 225,000 175 61 47,800 2,500 341 536 Cash $ 110.900 $ 295.965 Other financial information as of June 30, 2021: 1. Cash in bank $73,000 2. Mortgage Balance $3,600,000 3. Accounts Payable outstanding as of July 2021 is $25,000 4. The company purchased $250,000 worth of manufacturing equipment during the current fiscal year. Cash of $100,000 was paid on delivery with balance due on June 1, 2021. The amount has not been paid as of March 31, 2021. An additional $250,000 is planned for the coming year. 5. In June 2016, it purchased the current property for $6,000,000 (building and land), paying $1,200,000 down and agreeing to pay $300,000 plus 5% interest annually on the unpaid loan balance each July 1, starting on July 1, 2017. 6. Panel sales rose 4% in 2021 and expected sales to continue in the future. 7. Panel prices increased by 15% in 2021. The board expects to increase the panel prices by 15% in 2022. 8. Solar Panels pricing has not increased for 3 years. The policy by the Board is to encourage sales of solar panels to assist in overall sales. The company expects the percentage growth for 2021 to be the same for 2022. 9. Maintenance Equipment are expected to grow at the same rate as in 2021. 10. No other unpaid bills existed on June 30, 2021. 11. Operating expenses expected to increase: a. Plant and management wages to increase by 12% b. Plant Supplies, and Miscellaneous to increase by 28% c. Utilities by 10% The report is to include a Cash Budget for LYRIQ Panels Inc. as of June 30, 2022. After completing the cash budget identify three (3) operating items with an explanation for each. Also are the CFO concerns justified, and if so please explain
