Complete the npv analysis of the stamping machine proposal

Assignment Help Accounting Basics
Reference no: EM131484514

Topic 1 -

The CEO of Midwest 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 in the Table 1 (attached file):

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 11.0 percent (or, 0.11).

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.

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

Topic 3 -

The VP-Sales and Marketing of Midwest 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/10, 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, Q18,000,000 units

Budgeted unit selling, SP $15 per unit

Budgeted bad debts, BD1, as percent of sales 0.01 (or, 1.0 percent)

Budgeted unit variable cost, VC (excluding BD1) $8 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 10days

Under the proposed terms of sales:

Discount percentage, CD2 0.03 (or, 3.0 percent)

Discount period, DP2 10 days

Estimated bad debts, BD2, as percent of sales 0.015 (or, 1.5 percent)

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 indentified 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 Southwest 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.

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

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.

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

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

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

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

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

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

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.

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

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

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

The company's estimated cost of equity capital, rE, is 0.185 (18.5 percent), computed using CAPM as: rF + β x (rM - rF) = 0.04 + 1.7 x (0.125 - 0.04)

Attachment:- Assignment File.rar

Reference no: EM131484514

Questions Cloud

What is the expected growth rate in dividends : Golokwati Goldfields is trading at Gh¢5 per share and pays Gh¢3 per share in dividends. Investors require 15% return on this stock. What is the expected growth.
Discuss the capital budgeting task : This assignment has a 30% weighting in your overall mark for this unit and focuses on content from Topics 6, 7 and 8. It will be marked out of 30 and consists.
Defined benefit plan or the investment choice plan : What issues relating to the concept of the time value of money may be important in this decision-making process? Explain
Pure variable costs while inventory-holding costs : Does the EOQ increase or decrease if estimates of setup (order) costs include fixed, semi-variable and pure variable costs while inventory-holding costs?
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
Explain the value of beta that you have calculated : Collect the data from "YahooFinance" and answer the following questions (using the instructions given in the next page).
Why is that model viable in their industry : Why is that model viable in their industry?
Declining newspaper industry-describe its market position : Do a SWOT analysis for a declining newspaper industry and describe its market position.
Provide patent protection for pharmaceuticals : provide patent protection for pharmaceuticals. What about the effects for other industries?

Reviews

len1484514

5/5/2017 12:29:53 AM

The excel homework assignment below has five tabs that cover five different topics: Net Present Value Analysis, Capital Budgeting and Cost of Capital, Working Capital, Management, Financial Ratio Analysis, Projected Final Statements and Financing. When you complete the worksheets, please put in the proper formulas in each excel cell to show the work or formula on how you obtained the answer, and not just the answers. This will show me how answers were obtained, and I can use it learning aid for this class. Thanks!

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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