Reference no: EM131060584
Preparing Martin Manufacturing’s 2015 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 2015. The planned program is expected to lower the variable cost per unit of finished product. Terri Spiro, an experienced budget analyst, has been charged with preparing a forecast of the firm’s 2015 financial position, assuming replacement and modernization of manufacturing equipment. She plans to use the 2014 financial statements, along with the key projected financial data summarized in the attached table
Sales revenue $5,075,000
Less: Cost of goods sold 3,704,000
Gross Profit $1,371,000
Less: Operating expenses
Selling expense $650,000
General and administrative expenses $416,000
Depreciation expense $152,000
Total operating expense $1,218,000
Operating profit $153,000
Less: Interest expense $93,000
Net profit before taxes $60,000
Less: Income Taxes $24,000
Net profit $ 36,000
1. Use the historical and projected financial data provided to prepare a pro forma income statement for the year ended December 31, 2015. (Hint: Use the percent of sales method to estimate all values except depreciation and interest expense, which have been estimated by management and included in the table.)
2. Use the projected financial data along with relevant data from the pro forma income statement prepared in part (1) to prepare the pro forma balance sheet at December 31, 2015. (Hint: Use the judgmental approach.)
3. Will Martin Manufacturing Company need to obtain external financing to fund the proposed equipment modernization program? Explain
|
Determines if a password entered by a user is strong or not
: Must be at least 8 characters long Must contain at least 1 upper case character Must contain at least 1 digit Must not contain any spaces
|
|
The project is expected to have the other cash flows
: Middlefield Motors is evaluating a project that would cost 5,900 dollars today. The project is expected to have the following other cash flows: 2,280 dollars in 1 year, -2,250 dollars in 3 years, and 8,120 dollars in 4 years. The cost of capital of t..
|
|
Implications of consistency or change
: How would you describe East Asia's economic circumstances? Is growth a constant or is the region undergoing change? Which and explain why you say so? What are the implications of this consistency or change? EXPLAIN. Where is the change happening o..
|
|
Critical analysis about data security
: Critical analysis about Data security, examining recent relevant research, industry perspectives, public perspectives and current industry practice
|
|
Fund the proposed equipment modernization program
: Preparing Martin Manufacturing’s 2015 Pro Forma Financial Statements. To improve its competitive position, Martin Manufacturing is planning to implement a major equipment modernization program. Use the historical and projected financial data provided..
|
|
Expansion of biofuels might affect the market for corn
: Do you agree with this claim? Incorporating what you know about demand and supply, how do you think expansion of biofuels might affect the market for corn?
|
|
Determine the minimum frame size
: Suppose a CSMA/CD network is operating at 100Mbps, and suppose there are NO repeaters and the length of the cable is 1.0 km. Determine the minimum frame size if the signal propagation speed is 200 km/ms.
|
|
What you have learned about the lawsuit so far
: Based on what you have learned about the lawsuit so far, are the numbers sufficient evidence to support a claim of discrimination?
|
|
Create a table of contents for the investigative plan
: Describe the resources required to conduct a digital forensic investigation, including skill sets and required tools of the team members and create a table of contents for the investigative plan describing what the primary focus of the report would..
|