Need a paper written details and templates listed below

You’ve just been hired onto ABC Company as the corporate controller. ABC Company is a manufacturing firm that specializes in making cedar roofing and siding shingles. The company currently has annual sales of around $1.2 million, a 25% increase from the previous year. The company has an aggressive growth target of reaching $3 million annual sales within the next 3 years. The CEO has been trying to find additional products that can leverage the current ABC employee skillset as well as the manufacturing facilities.

As the controller of ABC Company, the CEO has come to you with a new opportunity that he’s been working on. The CEO would like to use the some of the shingle scrap materials to build cedar dollhouses. While this new product line would add additional raw materials and be more time-intensive to manufacture than the cedar shingles, this new product line will be able to leverage ABC’s existing manufacturing facilities as well as the current staff. Although this product line will require added expenses, it will provide additional revenue and gross profit to help reach the growth targets. The CEO is relying on you to help decide how this project can be afforded. Provide details about the estimated product costs, what is needed to break even on the project, and what level of return this product is expected to provide.

For the Final Paper make sure the content and written paper contain EACH of the following. Two major points: 1) you are to conduct scholarly research. This means no yahoo or Google finance, Wikipedia, Investopedia, blogs, etc.  and only use creditable sources for your research. 2) You must include your Scholarly Research in References and include citations. If you fail to include these two things your paper will be significantly impacts in the content areas. If there are no references or citations then the authority of your paper will be impacted. Quality Research (at least three, but no more than five Scholarly Research sources) and References/Citations.

Use this as a checklist to assure you have all content and writing aspects in your paper:

Content (provide in written format in a formal scholarly paper):

Part 1. Introduction and Outline the risk profile of the company.
Part 2. Company Cash Flow
     a. Complete a cash flow statement for the company using the direct method.
     b. Answer the following questions:

             i.      What does this statement of cash flow tell you about the sources and uses of the company?
         ii.     Is there anything ABC Company can do to improve the cash flow?
         iii.   Can this project be financed with current cash flow from the company? Why or why not?
         iv.   If the company needs additional financing beyond what ABC Company can provide internally (either now or sometime throughout the life of the project), how would you suggest the company obtain the additional financing, equity or corporate debt, and why?  

Part 3. Product cost problem for the company. Answer these questions.

a.     What is the product cost for the expansion product?
b.     By adding this new expansion product, it helps to absorb the fixed factory and sales expenses. How much cheaper does this expansion make the existing product?
c.     Assuming ABC Company wants a 40% gross margin for the new product, what selling price should it set for the expansion product?
d.     Assuming the same sales mix of these two products, what are the contribution margins and break-even point by product? 

Part 4. Potential investments to accelerate profit scenario. Answer the questions.

a.     What is the net present value of the proposed investment ignore income taxes and depreciation?
b.     Assuming a 5-year straight-line depreciation, how will this impact the factory’s fixed costs for each of the 5 years (and the implied product costs)? What about cash flow?
c.     Considering the cash flow impact of the equipment as well as the time-value of money, would you recommend that ABC Company purchases the equipment? Why or why not? 

Part 5. Conclusion:

a.     What are the major risk factors that you see in this project?
b.     As the controller and a management accountant, what is your responsibility to this project?
c.     What do you recommend the CEO do? 

Writing aspects of final paper:

    1.     Must be six to eight double-spaced pages in length, and formatted according to APA style as outlined.
2. Must include a title page with the following:
a.    Title of paper
b.    Student’s name
c.    Course name and number
d.    Instructor’s name
e.    Date submitted
3. Must begin with an introductory paragraph that has a succinct thesis statement.
4. Must address the topic of the paper with critical thought.
5. Must end with a conclusion that reaffirms your thesis.
6.     Must document at least three, but no more than five Scholarly Research sources in APA style as outlined.
7.  Must include a separate reference page, formatted according to APA style as outlined.

Use Appendix C for a single payment of present value. For instance I will have a dollar in one year. If the discount rate is $1 and of course it is one year, what is the value of that $1 today (it is something less that $1). The key is a single payment.

Use Appendix D when there are a series of payments. For instance, I have $10 and want to receive equal payments from that for 5 years and I will get 5% interest each year. What would my payment be?  Appendix D is Present Value of an annuity, which you can use if the amount is the exact same for a set term: $100 for 5 years. You can use this rather than the individual years, but the total of he five factors for those five years would total the factor in Appendix D.

2

>ABC Co Consolida Financial Info

pansion)

,2

X2

0,000

00,000

payable

$ 240,000

$ 750,000 $ 730,000

basis income statement revealed the following data:

$ 250,000

$ 70,000

Income taxes

																																																												ABC Company’s current financial information (before/without e						x
Dec.		3		1					0	Dec. 31,20X1
Cash	$		5		$ 70,000
Accounts receivable (net)	$ 120,000	$ 1	80,000
Merchandise inventory	$ 350,000	$ 280,000
Property plant, & equipment	$		4	$ 300,000
Less: Accumulated depreciation	$ (170,000)	$ (100,000)
Total assets		$ 750,000		$ 730,000
Accounts payable		$ 250,000	$ 210,000
	Income taxes	$	40,000	$ 10,000
Common stock		$ 240,000
Retained earnings	$ 220,000	$ 270,000
Total liabilities & stock, equity
The firm’s accrual	–
Sales	$ 1,200,000
Cost of goods sold	$ 800,000
selling and administrative expenses
Depreciation expense
$ 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.)

ABC Co Product information

80,000

40,000 5,000

dollars needed per product

$1.00 per Machine Hour

.20 per unit

$0.20 per unit

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		5,000
Machine Hours
Direct Materials	$1.30 per unit	$5.60 per unit
			Direct labor	$2.80 per unit	$4.00 per unit
Variable Factory Overhead		$1.00 per Machine Hour
Variable Selling Expense				$0
Total Fixed Costs:
Fixed Factory Overhead	$ 198,000
Fixed Selling expenses	$ 191,250

Product Cost and CM

Direct labor

0

per unit

(revenue per unit – variable product costs)

Direct materials
Direct labor
Variable factory overhead ($/machine hour)

Contribution 0

:#DIV/0!

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

PRODUCT COST-	Expansion product
		Direct materials
		Variable factory overhead ($/machine hour)
Fixed factory overhead ( total / total machine hours)
Product cost (excludes Selling expenses);
		Contribution					=
Current product
	Revenue per unit
	Contribution margin)		ERR	OR
	Break Even = Fixed overhead/Contribution

Cash Flow

Statement

$0

$0

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

Cash balance, January 1, 20X2

Cash balance, December 31, 20X2

*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

NPV

(using tables)

Present Value

0 – x

1 x =

2 x = – 0
3 x = – 0
4 x = – 0
5 x = – 0

ERROR:#VALUE!

OR
Year Cash Flow
0

1
2
3 NPV

4
5

Net	Present Value
a)	Investment	Savings	Present Value Factor at 12%
	Year
	ERROR:#VALUE!
				– 0
ERROR:#NAME?
Net Present Value (using Excel)
5 years of cash flows
Up front Investment
IRR
$0.00	ERROR:#NUM!
Rate

Appendix C

Present value interest factor of $1 per period at i% for n periods, PVIF(i,n).

P
e
rio

d
s

RATE PER PERIOD

1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% 16% 17% 18% 19% 20%

1 0.990 0.980 0.971 0.962 0.952 0.943 0.935 0.926 0.917 0.909 0.901 0.893 0.885 0.877 0.870 0.862 0.855 0.847 0.840 0.833

2 0.980 0.961 0.943 0.925 0.907 0.890 0.873 0.857 0.842 0.826 0.812 0.797 0.783 0.769 0.756 0.743 0.731 0.718 0.706 0.694

3 0.971 0.942 0.915 0.889 0.864 0.840 0.816 0.794 0.772 0.751 0.731 0.712 0.693 0.675 0.658 0.641 0.624 0.609 0.593 0.579

4 0.961 0.924 0.888 0.855 0.823 0.792 0.763 0.735 0.708 0.683 0.659 0.636 0.613 0.592 0.572 0.552 0.534 0.516 0.499 0.482

5 0.951 0.906 0.863 0.822 0.784 0.747 0.713 0.681 0.650 0.621 0.593 0.567 0.543 0.519 0.497 0.476 0.456 0.437 0.419 0.402

6 0.942 0.888 0.837 0.790 0.746 0.705 0.666 0.630 0.596 0.564 0.535 0.507 0.480 0.456 0.432 0.410 0.390 0.370 0.352 0.335

7 0.933 0.871 0.813 0.760 0.711 0.665 0.623 0.583 0.547 0.513 0.482 0.452 0.425 0.400 0.376 0.354 0.333 0.314 0.296 0.279

8 0.923 0.853 0.789 0.731 0.677 0.627 0.582 0.540 0.502 0.467 0.434 0.404 0.376 0.351 0.327 0.305 0.285 0.266 0.249 0.233

9 0.914 0.837 0.766 0.703 0.645 0.592 0.544 0.500 0.460 0.424 0.391 0.361 0.333 0.308 0.284 0.263 0.243 0.225 0.209 0.194

10 0.905 0.820 0.744 0.676 0.614 0.558 0.508 0.463 0.422 0.386 0.352 0.322 0.295 0.270 0.247 0.227 0.208 0.191 0.176 0.162

11 0.896 0.804 0.722 0.650 0.585 0.527 0.475 0.429 0.388 0.350 0.317 0.287 0.261 0.237 0.215 0.195 0.178 0.162 0.148 0.135

12 0.887 0.788 0.701 0.625 0.557 0.497 0.444 0.397 0.356 0.319 0.286 0.257 0.231 0.208 0.187 0.168 0.152 0.137 0.124 0.112

13 0.879 0.773 0.681 0.601 0.530 0.469 0.415 0.368 0.326 0.290 0.258 0.229 0.204 0.182 0.163 0.145 0.130 0.116 0.104 0.093

14 0.870 0.758 0.661 0.577 0.505 0.442 0.388 0.340 0.299 0.263 0.232 0.205 0.181 0.160 0.141 0.125 0.111 0.099 0.088 0.078

15 0.861 0.743 0.642 0.555 0.481 0.417 0.362 0.315 0.275 0.239 0.209 0.183 0.160 0.140 0.123 0.108 0.095 0.084 0.074 0.065

16 0.853 0.728 0.623 0.534 0.458 0.394 0.339 0.292 0.252 0.218 0.188 0.163 0.141 0.123 0.107 0.093 0.081 0.071 0.062 0.054

17 0.844 0.714 0.605 0.513 0.436 0.371 0.317 0.270 0.231 0.198 0.170 0.146 0.125 0.108 0.093 0.080 0.069 0.060 0.052 0.045

18 0.836 0.700 0.587 0.494 0.416 0.350 0.296 0.250 0.212 0.180 0.153 0.130 0.111 0.095 0.081 0.069 0.059 0.051 0.044 0.038

19 0.828 0.686 0.570 0.475 0.396 0.331 0.277 0.232 0.194 0.164 0.138 0.116 0.098 0.083 0.070 0.060 0.051 0.043 0.037 0.031

20 0.820 0.673 0.554 0.456 0.377 0.312 0.258 0.215 0.178 0.149 0.124 0.104 0.087 0.073 0.061 0.051 0.043 0.037 0.031 0.026

25 0.780 0.610 0.478 0.375 0.295 0.233 0.184 0.146 0.116 0.092 0.074 0.059 0.047 0.038 0.030 0.024 0.020 0.016 0.013 0.010

30 0.742 0.552 0.412 0.308 0.231 0.174 0.131 0.099 0.075 0.057 0.044 0.033 0.026 0.020 0.015 0.012 0.009 0.007 0.005 0.004

35 0.706 0.500 0.355 0.253 0.181 0.130 0.094 0.068 0.049 0.036 0.026 0.019 0.014 0.010 0.008 0.006 0.004 0.003 0.002 0.002

40 0.672 0.453 0.307 0.208 0.142 0.097 0.067 0.046 0.032 0.022 0.015 0.011 0.008 0.005 0.004 0.003 0.002 0.001 0.001 0.001

50 0.608 0.372 0.228 0.141 0.087 0.054 0.034 0.021 0.013 0.009 0.005 0.003 0.002 0.001 0.001 0.001 0.000 0.000 0.000 0.000

ABC Co Consolida Financial Info

payable

$ 240,000

$ 750,000 $ 730,000

$ 250,000

$ 70,000

Income taxes

		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	$ 1	80,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	$	40,000	$ 10,000
Common stock		$ 240,000
Retained earnings	$ 220,000	$ 270,000
Total liabilities & stock, equity
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
Depreciation expense
$ 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.)

ABC Co Product information

80,000

40,000 5,000

$1.00 per Machine Hour

$0.20 per unit

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		5,000
Machine Hours
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
Variable Selling Expense		$0.20 per unit
Total Fixed Costs:
Fixed Factory Overhead	$ 198,000
Fixed Selling expenses	$ 191,250