Question

In: Finance

Problem 5 –   Using the data provided complete the following projected Balance Sheet for Mumford Inc....


Problem 5 –  

Using the data provided complete the following projected Balance Sheet for Mumford Inc. as of and for the year ended December 31, 2020. Credit (and total) sales were $2,100,000. (Type in your values)) The long term debt is all interest bearing. The total stockholders’ equity is a combination of issued common stock and retained earnings.                    Problem 5 is continued on the next page.

Total asset turnover                       2.4 times
Cash to total assets                            2%
Accounts receivable turnover        8.0 times
Inventory turnover                          10.0 times
Current ratio                                       2.0 / 1.0
Debt to total assets                            61%                 


Assets                                                                    Liabilities

Cash                                                                       Current Debt

Accounts Receivable                                              Long Term Debt

Inventory                                                                 Total Debt

Total Current Assets
                                                                       Stockholders’ Equity

Fixed Assets (net of depr)               Total Stockholders’ Equity

TOTAL ASSETS                                                          TOTAL LIABILITIES AND STOCKHOLDERS’ EQUITY                                                       

Problem 5 continued –  

Mumford Inc. is using a combination of debt and equity in its capital structure. Identify two specific pros and two specific cons of each form of capital (interest bearing debt and issued common stock) and reflect upon (briefly discuss) what makes the item you identified either a pro or a con. The remaining space on this page should be plenty of room for an effective answer.

Solutions

Expert Solution

thumsup please if you like my answer


Related Solutions

Problem 5 –    Using the data provided complete the following projected Balance Sheet for Mumford Inc....
Problem 5 –    Using the data provided complete the following projected Balance Sheet for Mumford Inc. as of and for the year ended December 31, 2020. Credit (and total) sales were $2,100,000. (Type in your values)) The long term debt is all interest bearing. The total stockholders’ equity is a combination of issued common stock and retained earnings.    Total asset turnover                       2.4 times Cash to total assets                            2% Accounts receivable turnover        8.0 times Inventory turnover                          10.0 times Current ratio                                      ...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.1x Days sales outstanding: 30.5 days^a Inventory turnover ratio: 4x Fixed assets turnover: 2.5x Current ratio: 2.4x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 25% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $    Current liabilities $    Accounts receivable    Long-term debt 41,250...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.3x Days sales outstanding: 37.5 daysa Inventory turnover ratio: 7x Fixed assets turnover: 3.5x Current ratio: 2.1x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 35% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $   Current liabilities $   Accounts receivable    Long-term debt 52,500...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.4x Days sales outstanding: 31.5 daysa Inventory turnover ratio: 7x Fixed assets turnover: 3x Current ratio: 2.2x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 15% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $    Current liabilities $    Accounts receivable    Long-term debt 56,250...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.4x Days sales outstanding: 34 daysa Inventory turnover ratio: 4x Fixed assets turnover: 3.5x Current ratio: 2.5x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 35% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $    Current liabilities $    Accounts receivable    Long-term debt 56,250...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.2x Days sales outstanding: 39.5 daysa Inventory turnover ratio: 4x Fixed assets turnover: 3x Current ratio: 2.5x Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 25% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answer to the nearest cent. Balance Sheet Cash $   Current liabilities $   Accounts receivable    Long-term debt 50,000...
Complete the balance sheet and sales data (fill in the blanks), using the following financial data:...
Complete the balance sheet and sales data (fill in the blanks), using the following financial data: Debt/net worth 60% Acid test ratio 1.2 Asset turnover 1.5 times Day sales outstanding in accounts receivable 40 days Gross profit margin 30% Inventory turnover 6 times Balance sheet Cash ________ Accounts payable ________ Accounts receivable ________ Common stock $15,000 Inventories ________ Retained earnings $22,000 Plant & equipment ________ Total assets ________ Total liabilities ________ & capital Sales ________ Cost of goods sold ________.
eBook Problem Walk-Through Complete the balance sheet and sales information using the following financial data: Total...
eBook Problem Walk-Through Complete the balance sheet and sales information using the following financial data: Total assets turnover: 1.2× Days sales outstanding: 73.0 daysa Inventory turnover ratio: 4× Fixed assets turnover: 3.0× Current ratio: 2.5× Gross profit margin on sales: (Sales - Cost of goods sold)/Sales = 15% aCalculation is based on a 365-day year. Do not round intermediate calculations. Round your answers to the nearest dollar. Balance Sheet Cash $   Current liabilities $   Accounts receivable    Long-term debt 78,000...
Complete the projected Balance Sheet and Income Statement for Metza Metza, Inc. at December 31, 2020,...
Complete the projected Balance Sheet and Income Statement for Metza Metza, Inc. at December 31, 2020, given the following information: (you must show step by step calculations ). Also prepare a Common-size analysis of the Balance Sheet and Income Statement. What was their beginning Retained Earnings (actual) account balance at January 1, 2020 given a planned 40% Dividend Payout on December 31, 2020? Equity Multiplier                                             2.0x                                     Current Ratio                                                                                          2.5:1                                     Cash                                                                                                        5.0% of Sales                                     Quick...
Complete the following balance sheet using the information:                                &nbs
Complete the following balance sheet using the information:                                     Cash Accounts Receivables Inventory ________ Current Assets _________ Net Fixed Assets $1,000,000 _________ Total $1,300,000 ========= Current Ratio = 3.0 Inventory Turnover = 10.0 Debt Ratio = 30% Accounts Payables                         $100,000 Long-term Debt Total Liabilities Common Equity                                                            ________ Total                                                $1,300,000                                                                    ========= Total Asset Turnover = 0.5 Average Collection Period = 45 days Gross Profit Margin = 30%
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT