Need a paper written details and templates listed below

20180101FinalPaperSpreadsheetJRodischTemplate.xlsx

ABC Co Consolida Financial Info

ABC Company's current financial information (before/without expansion)
	Dec. 31,20X2	Dec. 31,20X1
Cash	$ 50,000	$ 70,000
Accounts receivable (net)	$ 120,000	$ 180,000
Merchandise inventory	$ 350,000	$ 280,000
Property plant, & equipment	$ 400,000	$ 300,000
Less: Accumulated depreciation	$ (170,000)	$ (100,000)
Total assets	$ 750,000	$ 730,000
Accounts payable	$ 250,000	$ 210,000
Income taxes payable	$ 40,000	$ 10,000
Common stock	$ 240,000	$ 240,000
Retained earnings	$ 220,000	$ 270,000
Total liabilities & stock, equity	$ 750,000	$ 730,000
The firm's accrual-basis income statement revealed the following data:
Sales	$ 1,200,000
Cost of goods sold	$ 800,000
selling and administrative expenses	$ 250,000
Depreciation expense	$ 70,000
Income taxes	$ 30,000
Dividends declared and paid during 20X2	$ 100,000
ABC purchased $100,000 of equipment for cash on August 14, 20X2
(There was no interest expense.)

Based on Chapter 5's exercise 5
ABC's Product information
	Current Product	Expansion Product (estimate)
Selling Price	$14.50	?
Units produced and expected to be sold	80,000	5,000
Machine Hours	40,000	5,000
Direct Materials	$1.30 per unit	$5.60 per unit
Direct labor dollars needed per product	$2.80 per unit	$4.00 per unit
Variable Factory Overhead	$1.00 per Machine Hour	$1.00 per Machine Hour
Variable Selling Expense	$0.20 per unit	$0.20 per unit
Total Fixed Costs:
Fixed Factory Overhead	$ 198,000
Fixed Selling expenses	$ 191,250

PRODUCT COST-Expansion product
Direct materials
Direct labor
Variable factory overhead ($/machine hour)
Fixed factory overhead ( total / total machine hours)
Product cost (excludes Selling expenses);				0
Contribution per unit = (revenue per unit – variable product costs)
Current product
Revenue per unit
Direct materials
Direct labor
Variable factory overhead ($/machine hour)
Contribution				0
Contribution margin)				ERROR:#DIV/0!
Break Even = Fixed overhead/Contribution
Expansion product
Revenue per unit
Direct materials
Direct labor
Variable factory overhead ($/machine hour)
Contribution				0
Contribution margin)				ERROR:#DIV/0!
Break Even = Fixed overhead/Contribution

CASH FLOW STATEMENT
Cash flows from operating activities
	Cash received from customers*
	Less cash payments for:
	Purchases of merchandise**
	Selling & administrative expenses
	Income taxes***
Net cash provided by operating activities
Cash flows from investing activities
	Purchase of equipment
Net cash provided by investing activities
Cash flows from financing activities
	Dividends paid
Net cash provided by financing activities
Net increase (decrease) in cash		$0
Cash balance, January 1, 20X2
Cash balance, December 31, 20X2		$0
*Cash received from customers = Sales + ( or - ) accounts receivable
**Purchases of merchandise = Cost of goods sold + (or - ) in merchandise inventory + (or - ) accounts payable
*** Income Taxes = Income tax expense - increase in income taxes payable ($30,000)
+ ( or - ) means increase of decrease in amount

Net Present Value (using tables)
a)	Investment	Savings		Present Value Factor at 12%		Present Value
Year
0	-		x			ERROR:#VALUE!
1			x		=	- 0
2			x		=	- 0
3			x		=	- 0
4			x		=	- 0
5			x		=	- 0
ERROR:#NAME?						ERROR:#VALUE!
OR
Net Present Value (using Excel)
5 years of cash flows
Year	Cash Flow
0		Up front Investment
1
2
3			NPV		IRR
4
5			$0.00		ERROR:#NUM!
Rate