Complete the npv analysis of the stamping machine proposal

Reference no: EM131174708

Problem 1 - The CEO of Southwest Manufacturing Company has asked for your analysis of and recommendation related to the proposed acquisition of an additional stamping machine for its principal manufacturing plant. Demand for the company's products has risen to a level that exceeds its present productive capacity. An additional stamping machine will make it possible for the company to increase its production and sales by 15 percent, resulting in projected incremental relevant cash flows (after income taxes and the tax benefits of the "depreciation tax shield") in each of the next five years, as indicated at right:

Year	Projected incremental cash flows
1	$20,000
2	30,000
3	40,000
4	30,000
5	20,000
Total	$140,000

The equipment will cost $100,000 to purchase and install. Management estimates that its economic life will be five years, after which it will have no residual value. The company's required rate of return on new investments (cost of capital) is 12.0 percent (or, 0.12).

a. Complete the NPV analysis of the stamping machine proposal, below. Regard all incremental relevant cash flows as "risky" and assume they occur at the end of years indicated, as listed above.

b. State your recommendation to the CEO, including the basis for it. Limit the length of your response to 50 words.

a. Complete the NPV analysis of the stamping machine proposal:
Year (n)	Relevant cash flow	Discount factor	Discounted cash flows
"Time zero"
1
2
3
4
5


b. State your recommendation to the CEO, including the basis for it. Limit the length of your response to 50 words.

Problem 2 - The VP-Operations of Southwest Manufacturing Company has asked for your review of her capital budgeting analysis, comparing two alternative machines the company is considering acquiring for one of its plants. Using the information provided in the table below, complete her analysis by computing the company's cost of equity capital, r_E, weighted average cost of capital, r_WACC, and the equivalent annual cost (EAC) for each machine under consideration. State your recommendation to the VP with regard to selecting one of these machines.

a. Compute the company's cost of equity capital, r_E. Show computations in good form and label properly all amounts presented.

b. Compute the company's weighted average cost of capital, r_WACC. Show computations in good form and label properly all amounts presented.

c. Compute the equivalent annual cost (EAC) for each machine under consideration, ignoring "cost recovery" income tax deductions, the tax deductibility of ownership costs, and capital gains taxes upon the machine's disposal). Show computations in good form and label properly all amounts presented.

d. State your recommendation to the VP-Operations, including the basis for it. Limit the length of your response to 50 words.

Problem 3 - The VP-Sales and Marketing of Southwest Manufacturing Company has asked for your analysis of her proposal to modify the company's current terms of sale, "2/10, net/30." She has proposed more generous terms - "3/5, net/30" - in order to promote increased sales and market share. She has acknowledged that more generous terms may also lead to increased bad debts. The business' operating budget for the forthcoming fiscal year includes the following relevant information:

Budgeted unit sales, Q₁	5,000,000	units
Budgeted unit selling, SP	$20	per unit
Budgeted bad debts, BD₁, as percent of sales	0.01	(or, 1.0 percent)
Budgeted unit variable cost, VC (excluding BD₁)	$10	per unit
Combined effective income tax rate, t	0.40	(or, 40.0 percent)
Current interest rate on business' debt, r_D	0.12	(or, 12.0 percent)

In addition, based on the existing terms of sales:
Discount percentage, CD₁	0.02	(or, 2.0 percent)
Discount period, DP₁	10	days

Under the proposed terms of sales:
Discount percentage, CD₂	0.03	(or, 3.0 percent)
Discount period, DP₂	5	days
Estimated bad debts, BD₂, as percent of sales	0.015	(or, 1.5 percent)

a. Compute the NPV of the company's existing terms of sales based on its operating budget and other information provided, above. Show computations in good form and label properly all amounts presented.

b. Compute the required sales volume, Q₂, under the proposed terms of sale necessary to achieve the NPV of the existing credit policy - i.e., the "break even" unit sales volume. Show computations in good form and label properly all amounts presented.

Problem 4 - Demonstrate your ability to apply financial ratio analysis to common-sized financial statements. Analyze the common-sized balance sheet and income statement of FirstRate Company, included in the Topic 8 background paper, Financial Ratio Analysis. Identify the most significant:

-Trends in the 20X0 - 20X4 common-sized financial information, and

-Differences between the common-sized financial information of the company and its industry's norms

Your analysis should indicate the basis on which you identified trends or differences as significant, including the potential implications for FirstRate's business or financial condition.

Limit your response to a maximum of 200 words. Spell-check and-grammar-and-style-check your completed response using MS Word's tool for this purpose, being sure to correct any matters identified by these checking tools.

Problem 5 - The CEO of North American Manufacturing Company has asked you to (a) complete the projected income statement and projected balance sheet for the coming fiscal year (FY) of the company using the information set forth below. She has also asked you to (b) determine the amount of any additional external financing the company will require during the coming fiscal year and (c) assess the reasonableness of the projections in relation to the company's estimated cost of equity capital, rE, and its sustainable sales growth rate.

1. Use the average gross margin during the preceding two-year period to project the amount of gross profit.

2. Use the average ratio of "all other S&A-to-sales revenue" during the preceding two-year period to project the amount of all other S&A expense.

3. Use the average amount of R&D expense during the two preceding FYs to project the amount of this expense.

4. The estimated combined effective income tax rate during the projected FY is 0.40 (40.0 percent).

5. Project the balances of cash and cash equivalents, total current assets, and total liabilities as "residual amounts" using the general methodology examined in Topic 9 of the course. Project total assets using the projected balance of total liabilities and shareholders' equity. Project the balance of total liabilities and stockholders' equity based on projected total stockholders' equity and a targeted total debt ratio (ratio of total liabilities-to-total stockholders' equity) of 0.70 (70 percent).

6. Project the balance of accounts receivable (AR) using a projected average AR collection period ratio of 45 days.

7. Project the balance of inventory using a projected average days to sell inventory ratio of 90 days.

8. Project the balance of other assets using the average balance of this item during the two preceding FYs.

9. Project the balance of accounts payable (AP) using projected "cash costs" and a projected average AP payment period of 45 days. "Cash costs" include projected COGS and operating expenses, excluding depreciation.

10. Project the balance of dividends payable as the dividends that the company expects to declare during the final week of the projected FY (based on net income for that year) and pay early in the next FY. The company's payout ratio (dividend policy) is 0.40 (40 percent).

11. The company plans no issuances (or repurchases) of common stock during the projected FY.

12. Project retained earnings (RE) using projected net income and projected dividends to be declared near the end of the projected FY.

13. The company's estimated cost of equity capital, r_E, is 0.227 (22.7 percent), computed using CAPM as: r_F + β x (r_M - r_F) = 0.04 + 2.2 x (0.125 - 0.04)

a. Projected income statement

a. Projected income statement
		Actual (historical)		Projected	Computational Notes
		20X0	20X1	20X2	(Formulas or equations used)
(A)	Sales revenue	$48,500,000	50,900,000	$ 55,000,000	Given
	Cost of goods sold (COGS):
(B)	Deprec. of manufacturing PP&E	6,695,000	6,985,000	7,300,000	Given
(C)	All other COGS	25,800,000	26,100,000
(D)	Total COGS	32,495,000	33,085,000
(E)	Gross profit	$ 16,005,000	17,815,000
(F)	Gross margin	33.0%	35.0%
	Operating expenses:
	Selling and admin. (S&A) exp.:
(G)	Deprec. of non-mfg PP&E	$ 360,000	520,000	$ 700,000	Given
(H)	All other S&A expense	5,820,000	6,108,000
(I)	Research and devel. (R&D) exp.	1,290,000	1,510,000
(J)	Other operating expenses	135,000	177,000	200,000	Given
(K)	Total operating expenses	7,605,000	8,315,000
(L)	Operating income	8,400,000	9,500,000
(M)	Interest on debt	(660,000)	(750,000)	(810,000)	Given
(N)	Income from investments	10,000	10,000	10,000	Given
(O)	Gain (loss) on PP&E disposals	-	(94,000)	-	Given
(P)	Income before taxes	7,750,000	8,666,000
(Q)	Provision for income taxes	3,100,000	3,466,000
(R)	Net income	$ 4,650,000	5,200,000

a. (continued) Projected balance sheet
	Assets:	Actual (historical)		Projected	Computational Notes
	Current assets:	20X0	20X1	20X2	(Formulas or equations used)
(A)	Cash and cash equivalents	$ 450,000	690,000
(B)	Investment securities	200,000	200,000	200,000	Given
(C)	Accounts receivable	6,060,000	6,360,000
(D)	Inventory	8,120,000	8,270,000
(E)	Total current assets	14,830,000	15,520,000
	Current ratio (working capital) ratio	1.0	1.0
(F)	PP&E, at cost	38,510,000	45,790,000	53,800,000	Given
(G)	Accumulated depreciation of PP&E	14,260,000	20,340,000	26,300,000	Given
(H)	PP&E, net	24,250,000	25,450,000
(I)	Other assets	600,000	900,000
(J)	Total assets	$ 39,680,000	41,870,000
	Liabilities:
	Current liabilities:
(K)	Accounts payable	$ 4,130,000	4,240,000
(L)	Accrued income taxes payable	780,000	870,000	900,000	Given
(M)	Dividends payable	1,860,000	2,080,000
(N)	Bank notes payable - current	7,800,000	8,000,000	8,800,000	Given
(O)	Accrued interest payable	170,000	190,000	200,000	Given
(P)	Total current liabilities	14,740,000	15,380,000
(Q)	Bank notes payable - noncurrent	4,800,000	3,230,000
(R)	Total liabilities	19,540,000	18,610,000
	Total debt ratio	0.97	0.80
	Stockholders' equity:
(S)	Common stock, at par	12,500,000	12,500,000
(T)	Additional paid-in capital	2,600,000	2,600,000
(U)	Retained earnings	5,040,000	8,160,000
(V)	Total stockholders' equity	20,140,000	23,260,000
(W)	Total liab. and stockhldrs' equity	$ 39,680,000	41,870,000

b. Determine the amount of any additional external financing the company will require during the coming FY. Show computations in good form and label properly all amounts presented.

c. Assess the reasonableness of the projected financial statements in relation to the company's estimated cost of equity capital, r_E, and its sustainable sales growth rate.

c. Assess the reasonableness of the projected financial statements in relation to the company's estimated cost of equity capital, r_E, and its sustainable sales growth rate.
	Actual (historical)		Projected
	20X0	20X1	20X2
Return on average common equity (ROCE) ratio	24.8%	24.0%	%
Net income (available to common stockholders)	$ 4,650,000	5,200,000	$
Total stockholders' equity, beginning of FY	17,350,000	20,140,000	$
Total stockholders' equity, end of FY	20,140,000	23,260,000	$
Average total stockholders' equity	$ 18,745,000	21,700,000	$

Sustainable rate of sales growth			%
Net income (available to common stockholders)			$
Beginning-of-year shareholders' equity			$
Payout ratio			%
Assessment of projected ROCE and sustainable growth rate in sales ratios (limit your response to a maximum of 100 words):

Reference no: EM131174708

Questions Cloud

Find the amount of salt in the tank at any time t : a. Find the amount of salt in the tank at any time t. b. Find the time at which the mixture in the tank contains 0.5 kg of salt.

What was paid for the stock : A person sold shares of stock at a loss of 20% (Assume no commissions and fees). If the selling price for the shares was $50,000, what was paid for the stock?

Find the damping constant : A guitar string is pulled at point P a distance of 2cm above its rest position. It is then released and vibrates in damped harmonic motion with a frequency of 170 cycles per second. After 1s, it is observed that the amplitude of the vibration at p..

What are the critical issues a company must consider : What are the critical issues a company must consider when trying to develop an effective organizational communication strategy.

Complete the npv analysis of the stamping machine proposal : Complete the NPV analysis of the stamping machine proposal, below. Regard all incremental relevant cash flows as "risky" and assume they occur at the end of years indicated, as listed above

What is the amount of allowable foreign income tax credit : Dave is a U.S. citizen who works in a foreign country for a few months- What is the amount of the allowable foreign income tax credit that can be claimed by Dave?

Does organizational buying affect consumer buying : Compare and contrast three selected features of organizational buying with corresponding features of consumer buying. What is the role of organizational culture in organizational buying? Use at least one example of a company mentioned (APPLE, INC)..

Determine two strategies that hershey is actually pursuing : Go to the www.hersheycompany.com website and click on Newsroom. Read through the most recent 10 press releases. Determine two strategies that Hershey is actually pursuing. Give some pros and cons of those two new Hershey strategies.

Draw a graph that models the swimmer''s depth : Draw a graph that models the swimmer's depth below the water's surface over time.

User Account

All Pages