Ive seen a couple of answers similar or exactly like this one, but how some experts answered them, i dont understand how im to put those numbers into the correct place. so if you could just make a table similar to what i have on my screen with the answers inside the correct boxes, thatd be lovely.

Preparing Martin Manufacturing's 2013 Pro Forma Financial Statements To improve its competitive position, Martin Manufacturing is planning to implement a major equipment modernization program. Included will be replacement and modernization of key manufacturing equipment at a cost of $400,000 in 2013. The planned program is expected to lower the variable cost per unit of finished product. Tem Spiro, an experienced budget analyst, has been charged with preparing a forecast of the firm's 2013 financial position, assuming replacement and modernization of manufacturing equipment. She plans to use the 2012 financial statements, along with the key projected financial data summarized in the following table To Do Use the Nistorical and projected financial data provided to prepare a pro forma income statement for the year ended December 31, 2013. (Hint Use the percent-of-sales method to estimate all values except depreciation expense and interest expense, which have been estimated by management and included in the table) b. Use the projected financial data along with relevant data from the pro forma income statement prepared in part (a) to prepare the pro forma balance sheet at December 31, 2013. (Hint: Use the judgmental approach) Wil Martin Manufacturing Company need to obtain external financing to fund the proposed equipment modemization program? Explain a. Use the historical and projected financial data provided to prepare a pro forma income statement for the year ended December 31, 2013. (Hint: Use the percent-of-sales method to estimate al values except depreciation expense and interest expense, which have been estimated by management and included in the table) (Round the dollar amounts to the nearest dollar. Round the percentages of sale to four decimal places. NOTE: Make Complete the pro forma income statement for the year ended December 31, 2013 below sure you use the rounded amounts to performed the proceeding calculations) Martin Manufacturing Company Pro Forma Income Statement for the Year Ended December 31, 2013 Sales revenue Less Cost of goods sold Gross profits Less Operating expenses Selling expense and general and administrative expense Depreciation expense 100.0 % Total operating expenses Operating profits Less: Interest expense Net profits before taxes Less Taves (40%) Total profits after taxes Data table Martin Manufacturing Company Income Statement for the Year Ended December 31, 2012 Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses Selling expense General and administrative expenses Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate = 40%) Net profits after taxes Less: Preferred stock dividends Print Done Thun $650,000 416,000 152,000 $5,075,000 3,704,000 $1,371,000 1,218,000 $153,000 93,000 $60,000 24,000 $36,000 3,000 sting and Data table Earnings available for common stockholders Earnings per share (EPS) Assets Current assets Cash Question 18. Chapter 4 Case (static) Martin Manufacturing Company Balance Sheets December 31, 2012 Accounts receivable Inventories Lintilition and Total current assets Gross fixed assets (at cost) Less: Accumulated depreciation Net fixed assets Total assets weide Print Done $33,000 $0.33 $25,000 805,556 700,625 HW Score: 73.68%. 28 of X $1,531,181 $2,093,819 500,000 $1,593,819 $3,125,000 D - Current liabilities Accounts payable Notes payable Accruals Total current liabilities Long-term debt Total liabilities Stockholders' equity Preferred stock (2,500 shares, $1.20 dividend) Common stock (100,000 shares at $4.00 par)" Paid-in capital in excess of par value Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $230,000 311,000 75,000 $616,000 $1,165,250 $1,781,250 $50,000 400,000 593,750 300,000 $1,343,750 $3,125,000 *The firm's 100,000 outstanding shares of common stock closed 2012 at a price of $11.38 per share. Martin Manufacturing Company Key Projected Financial Data (2013) Data item Value Sales revenue Minimum cash balance Inventory turnover (times) Average collection period Fixed-asset purchases Total dividend payments (preferred and common) Depreciation expense Interest expense Accounts payable increase Accruals and long-term debt Notes payable, preferred and common stock $6,500,000 $25,000 7.0 50 days $400,000 $20,000 $185,000 $97,000 20% Unchanged Unchanged Preparing Martin Manufacturing's 2013 Pro Forma Financial Statements To improve its competitive position, Martin Manufacturing is planning to implement a major equipment modernization program. Included will be replacement and modernization of key manufacturing equipment at a cost of $400,000 in 2013. The planned program is expected to lower the variable cost per unit of finished product. Tem Spiro, an experienced budget analyst, has been charged with preparing a forecast of the firm's 2013 financial position, assuming replacement and modernization of manufacturing equipment. She plans to use the 2012 financial statements, along with the key projected financial data summarized in the following table To Do Use the Nistorical and projected financial data provided to prepare a pro forma income statement for the year ended December 31, 2013. (Hint Use the percent-of-sales method to estimate all values except depreciation expense and interest expense, which have been estimated by management and included in the table) b. Use the projected financial data along with relevant data from the pro forma income statement prepared in part (a) to prepare the pro forma balance sheet at December 31, 2013. (Hint: Use the judgmental approach) Wil Martin Manufacturing Company need to obtain external financing to fund the proposed equipment modemization program? Explain a. Use the historical and projected financial data provided to prepare a pro forma income statement for the year ended December 31, 2013. (Hint: Use the percent-of-sales method to estimate al values except depreciation expense and interest expense, which have been estimated by management and included in the table) (Round the dollar amounts to the nearest dollar. Round the percentages of sale to four decimal places. NOTE: Make Complete the pro forma income statement for the year ended December 31, 2013 below sure you use the rounded amounts to performed the proceeding calculations) Martin Manufacturing Company Pro Forma Income Statement for the Year Ended December 31, 2013 Sales revenue Less Cost of goods sold Gross profits Less Operating expenses Selling expense and general and administrative expense Depreciation expense 100.0 % Total operating expenses Operating profits Less: Interest expense Net profits before taxes Less Taves (40%) Total profits after taxes Data table Martin Manufacturing Company Income Statement for the Year Ended December 31, 2012 Sales revenue Less: Cost of goods sold Gross profits Less: Operating expenses Selling expense General and administrative expenses Depreciation expense Total operating expense Operating profits Less: Interest expense Net profits before taxes Less: Taxes (rate = 40%) Net profits after taxes Less: Preferred stock dividends Print Done Thun $650,000 416,000 152,000 $5,075,000 3,704,000 $1,371,000 1,218,000 $153,000 93,000 $60,000 24,000 $36,000 3,000 sting and Data table Earnings available for common stockholders Earnings per share (EPS) Assets Current assets Cash Question 18. Chapter 4 Case (static) Martin Manufacturing Company Balance Sheets December 31, 2012 Accounts receivable Inventories Lintilition and Total current assets Gross fixed assets (at cost) Less: Accumulated depreciation Net fixed assets Total assets weide Print Done $33,000 $0.33 $25,000 805,556 700,625 HW Score: 73.68%. 28 of X $1,531,181 $2,093,819 500,000 $1,593,819 $3,125,000 D - Current liabilities Accounts payable Notes payable Accruals Total current liabilities Long-term debt Total liabilities Stockholders' equity Preferred stock (2,500 shares, $1.20 dividend) Common stock (100,000 shares at $4.00 par)" Paid-in capital in excess of par value Retained earnings Total stockholders' equity Total liabilities and stockholders' equity $230,000 311,000 75,000 $616,000 $1,165,250 $1,781,250 $50,000 400,000 593,750 300,000 $1,343,750 $3,125,000 *The firm's 100,000 outstanding shares of common stock closed 2012 at a price of $11.38 per share. Martin Manufacturing Company Key Projected Financial Data (2013) Data item Value Sales revenue Minimum cash balance Inventory turnover (times) Average collection period Fixed-asset purchases Total dividend payments (preferred and common) Depreciation expense Interest expense Accounts payable increase Accruals and long-term debt Notes payable, preferred and common stock $6,500,000 $25,000 7.0 50 days $400,000 $20,000 $185,000 $97,000 20% Unchanged Unchanged