Complete the npv analysis of the stamping machine proposal

Assignment Help Financial Accounting
Reference no: EM131217487

Topic 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.

Topic 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, rE, weighted average cost of capital, rWACC, 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, rE. Show computations in good form and label properly all amounts presented.

b. Compute the company's weighted average cost of capital, rWACC.  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. 

Topic 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, Q1

5,000,000

units

Budgeted unit selling, SP

$20

per unit

Budgeted bad debts, BD1, as percent of sales

0.01

(or, 1.0 percent)

Budgeted unit variable cost, VC (excluding BD1)

$10

per unit

Combined effective income tax rate, t

0.40

(or, 40.0 percent)

Current interest rate on business' debt, rD

0.12

(or, 12.0 percent)

 

 

 

In addition, based on the existing terms of sales:

 

 

Discount percentage, CD1

0.02

(or, 2.0 percent)

Discount period, DP1

10

days

 

 

 

Under the proposed terms of sales:

 

 

Discount percentage, CD2

0.03

(or, 3.0 percent)

Discount period, DP2

5

days

Estimated bad debts, BD2, 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, Q2, 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.

Topic 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. 

Topic 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, rE, is 0.227 (22.7 percent), computed using CAPM as:    rF + β x (rM - rF) = 0.04 + 2.2 x (0.125 - 0.04)

a. Prepare Projected income statement & Projected balance sheet

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, rE, and its sustainable sales growth rate. 

Verified Expert

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 $29,000,000.00 COGS - Deprec. (D) Total COGS 32,495,000 33,085,000 $36,300,000.00 Sales - Gross Profit (E) Gross profit $16,005,000 17,815,000 $18,700,000.00 Sales * Gross Margin (F) Gross margin 33.00% 35.00% 34.00% (33%+35%)/2 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 $6,600,000 [(5820000/48500000) + (6108000/50900000)]/2

Reference no: EM131217487

Questions Cloud

Quality control activity analysis : Cost of quality report A quality control activity analysis indicated the following four activity costs of a manufacturing department:
Profit increase or decrease if the order is accepted : Special Order Smooth Move Company manufactures professional paperweights and has been approached by a new customer with an offer to purchase 15,000 units at a per-unit price of $7.00. The new customer is geographically separated from Smooth Move's ot..
Some analytical procedures that heiss might perform : The audit of GolfDay Company, a manufacturer of bicycle racks and golf carts, is almost finished. Krista Heiss is the most experienced auditor on this audit and is in charge of performing review analytical procedures. What are some analytical procedu..
Calculate cash conversion cycle : Strickler Technology is considering changes in its working capital policies to improve its cash flow cycle. Strickler's sales last year were $140,000 (all on credit), and it earned a net profit of 6%. Calculate Strickler's cash conversion cycle. What..
Complete the npv analysis of the stamping machine proposal : 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 ..
Costs of performing these random sample tests : Barksdale Manufacturing Inc. produces its products in batches containing 100 units. Barksdale randomly samples 15 of the units in each batch for quality control. The costs of performing these random sample tests would most likely be which type of qua..
Company unrealized gain on short-term investments : Apple Inc. accumulates large amounts of excess cash throughout the year. It typically invests these funds in marketable securities until they are needed. The company’s most recent financial statements revealed a nearly $160 million unrealized gain on..
Determine the amount at which cash and cash equivalents : The Cash account in the general ledger of Lyco Corporation showed a balance of $21,749 at December 31 (but prior to performing a bank reconciliation). The company’s bank statement showed a balance of $22,000 at the same date. Prepare the company’s De..

Reviews

Write a Review

Financial Accounting Questions & Answers

  Tax rates and investment returns are constant over time

Suppose that the tax rate on personal income, tp, is equal to 40%; the corporate tax rate, tc, is equal to 35%; and the capital gains tax rate, tcg, is 20%. Also assume that the before-tax rate of return on investment to both the corporate and partne..

  The production department has been investigating possible

the production department has been investigating possible ways to trim total production costs. one possibility

  Sierra corporation on january

Padre, Inc., buys 80 percent of the outstanding common stock of Sierra Corporation on January 1, 2015, for $802,720 cash. At the acquisition date, Sierra's total fair value, including the non-controlling interest, was assessed at $1,003,400 although ..

  Assume allan applies the equity method

Assume Allan applies the equity method to its Investment in Bellevue account

  Prepare the journal entry to record organizational costs

Horace Greeley Corporation was organized in 2013 and began operations at the beginning of 2014. The company is involved in design consulting services. the following costs were incurred prior to the start of operations: Compute the total amount of org..

  Bond discount and entries for bonds payable transactions

Bond Discount, Entries for Bonds Payable Transactions, Interest Method of Amortizing Bond Discount. On July 1, 2014, Bliss Industries, Inc. issued $58,000,000 of 20-year, 11% bonds at a market (effective) interest rate of 14%, receiving cash of $46,4..

  Mate boomerang corporation manufactures and sells plastic

mate boomerang corporation manufactures and sells plastic boomerangs. expected boomerang sales in units for the

  Risk and security and identification their role in finance

Definition of Risk and Security and identification their role in finance.

  Class of equipment using revaluation accounting

Sunshine Company acquired equipment on January 1, 2015, for $40,000. Sunshine elects to value this class of equipment using revaluation accounting as permitted by International Financial Reporting Standard. This equipment is being depreciated on a st..

  Prepare a post-closing trial balance

Prepare an adjusted trial balance and pepare an income statement, a statement of retained earnings, and an unclassified balance sheet.

  Prepare an income tax return for carrie

Prepare an income tax return for Carrie for 2012 - Make necessary assumptions for information not given in the problem.

  What is the variable rate for airplane depreciation

What is the variable rate for airplane depreciation? The fixed cost? What is the cost formula for airplane depreciation? What is the variable rate for fuel? The fixed cost?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd