Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need calculations/formulas shown as well Suzy Q Muffins is expecting a 20 percent increase in sales next year, and management is concerned about the company's

Need calculations/formulas shown as well

image text in transcribed

Suzy Q Muffins is expecting a 20 percent increase in sales next year, and management is concerned about the company's need for external funds. The increase in sales is expected to be carried out without any expansion of capital assets; instead it will be done through more efficient asset utilization in the existing stores. Of liabiilities, only current liabilities vary directly with sales. a. Using the percent-of-sales method, determine whether Suzy Q Muffins has external financing needs.(9 marks) \% expected increase Profit margin Payout ratio Change in sales (\$) Spontaneous assets as \% of sales Spontaneous liabilities as % of sales Does your company require funds? Explain based on your calculations ( 2 marks): Change in assets Change in liabilities Change in retained earnings External funding needed b. Prepare a pro forma balance sheet with any financing adjustment made to notes payable. c. Calculate the current ratio and total debt to assets ratio for each year ( 4 marks). (8 marks) Balance Sheet Discuss your findings (4 marks) \begin{tabular}{ll} Assets & Liabilities and Shareholders' Equity \\ Cash & Accounts payable \\ Account receivable & Accrued wages \\ Inventory & Accrued taxes \\ Current assets & Current liabilities \\ Capital assets & Notes payable \\ & Long-term debt \\ & Shareholders' Equity \\ & Common shares \\ & Retained earnings \\ & Total liabilities \\ \hline Total assets & and shareholders' equity \\ \hline \hline \end{tabular} Suzy Q Muffins is expecting a 20 percent increase in sales next year, and management is concerned about the company's need for external funds. The increase in sales is expected to be carried out without any expansion of capital assets; instead it will be done through more efficient asset utilization in the existing stores. Of liabiilities, only current liabilities vary directly with sales. a. Using the percent-of-sales method, determine whether Suzy Q Muffins has external financing needs.(9 marks) \% expected increase Profit margin Payout ratio Change in sales (\$) Spontaneous assets as \% of sales Spontaneous liabilities as % of sales Does your company require funds? Explain based on your calculations ( 2 marks): Change in assets Change in liabilities Change in retained earnings External funding needed b. Prepare a pro forma balance sheet with any financing adjustment made to notes payable. c. Calculate the current ratio and total debt to assets ratio for each year ( 4 marks). (8 marks) Balance Sheet Discuss your findings (4 marks) \begin{tabular}{ll} Assets & Liabilities and Shareholders' Equity \\ Cash & Accounts payable \\ Account receivable & Accrued wages \\ Inventory & Accrued taxes \\ Current assets & Current liabilities \\ Capital assets & Notes payable \\ & Long-term debt \\ & Shareholders' Equity \\ & Common shares \\ & Retained earnings \\ & Total liabilities \\ \hline Total assets & and shareholders' equity \\ \hline \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Banking And Finance

Authors: Brian Duignan

1st Edition

1615308946, 978-1615308941

More Books

Students also viewed these Finance questions