Question: After performing the ratio analysis, developing common-size financial statements, and examining return on equity by the DuPont method, Warren Lynch presented his findings and recommendations

After performing the ratio analysis, developing common-size financial statements, and examining return on equity by the DuPont method, Warren Lynch presented his findings and recommendations for CompU to Bill Jobs. Warren stated that the large decrease in cash and the use of short-term debt concerned him and recommended doing cash and profit planning to make sound financing and expansion decisions. He also pointed out that the cost of goods sold was increasing and needed further analysis. Bill agreed, and thanked Warren for his hard work. Bill said he would talk to their suppliers and determine what was driving the increased costs while Warren started the cash and profit planning process. Warren said he would develop pro forma financial statements to forecast future profits and financing required.

  1. Using the financial statements for 2020 and 2021, information given, prepare the pro forma income statement and balance sheet for 2022. How much additional financing will CompU need?
  2. Based on the amount of additional financing requirements, what recommendations would you make to Warren in regards to the type of financing to pursue? What types of adjustments could CompU make in the operational forecast to reduce the amount of financing needed while still growing the business?

Information for pro forma financial statements:

  1. Sales are forecast to increase by 41.667% in 2022.
  2. Cash on the balance sheet will equal the $25,000 minimum cash balance Warren wants maintained.
  3. Additional fixed assets of $320,000 will be purchased in 2022.
  4. Warren wants to issue long-term debt of $175,000 and use the proceeds to pay down notes payable.
  5. Costs of Goods Sold, SG&A Expense, Accounts Receivable, Inventory, Accounts Payable, and Accruals will change in direct response to the change in sales.
  6. Common stock will remain unchanged.
  7. Depreciation expense will equal $75,000 for 2022.
  8. Interest expense will equal $40,000 for 2022.
  9. CompUs tax rate is 40%.
  10. Dividends of $2,500 will be paid in March, June, September, and December.

After performing the ratio analysis, developing common-size financial statements, and examining return

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!