Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Basic Finance Expert

Use the project data given below to build a spreadsheet to:
1. find out the cash flows for all years of this project.
2. find out the WACC for this project.
3. find out the NPV and IRR for this project.
4. Use an IF statement to generate a decision for this project in a worksheet other than the worksheet that find outs the project's cash flows.

Rye Baking Company is considering replacing its manual bread mixing and baking process with a new mixing and baking machine for its specialty breads. The proposed new machine has a purchase price of $340,200 and a cost of $4,000 to ship and install. This cost will be depreciated straight-line to zero over the project's 5-year tax life. The project life of the mixing/baking system for the bakery, however, is 4 years, at the end of which the mixing system is expected to be scrapped for $65,500.

The new mixing and baking system is expected to make a better quality product and the bakery expects to see sales increase by $107,200 per year. The bakery does not expect the new machine to make any change in total operating costs. The proposed new system requires an initial investment in a net working capital of $48,200. The company's tax rate is 34 percent.

The company wants to maintain a 0.36 debt to equity ratio. The YTM on the company's existing bonds is 5.9 percent. The company's stock is selling for $78.00 per share and it just paid a dividend of $2.30 per share. Dividends are expected to grow at an average constant rate of 4.2 percent per year.

Note: The NPV function in Excel is not correctly programmed to find out NPV as the term is used in finance. The Excel NPV function find outs only the PV of the future cash flows and does not include the initial outlay in its formulation. Adjust your spreadsheet formulation to reflect this programming error. Double check the spreadsheet results with the calculator to be sure spreadsheet results are correct.

The spreadsheet must include:
- At least two worksheets - with at least one worksheet for inputs and summary of output (results).
- At least 2 different types of number format.
- At least 2 different colors for cell highlighting.
- All calculations must be done within the spreadsheet.
- All formulated cell calculations must use cell references (the number inputs must be first listed or input in another cell).
- Use at least one IF statement to automatically generate a project accept/reject decision.
- Use at least 2 built-in formulas or functions (fx),other than =IF (e.g., =sum(D3:F3), =NPV(rate,A3:A9), etc.).
- Include at least 1 cell with a defined name (see the name manager under the formula tab).

 

Basic Finance, Finance

  • Category:- Basic Finance
  • Reference No.:- M926002

Have any Question? 


Related Questions in Basic Finance

1 contact your local ham radio organization and take a

1. Contact your local ham radio organization and take a certification course. Use your certification to get involved in local response. You can get more information from the Amateur Radio Relay League (ARES; http://www.a ...

Explain how you would conduct the study you designed in

Explain how you would conduct the study you designed in Question 1 as a matched-subjects design. Question 1 Design a randomized groups experiment to test the hypothesis that children who watch an hour-long violent televi ...

1 how does the creation of a secondary market in mortgages

1. How does the creation of a secondary market in mortgages help to promote home ownership? Why might the federal government decide to intervene in the housing market to promote home ownership? 2. Go to the Web site of t ...

1 distinguish between concurrent and predictive validity do

1. Distinguish between concurrent and predictive validity. Do these terms refer to types of construct validity or criterion-related validity? 2. How can we tell whether a particular measure is biased against a particular ...

Finance homeworkdevelop a three- to four-page analysis

Finance homework Develop a three- to four-page analysis (excluding the title and reference pages) on the projected return on investment for your college education and projected future employment. This analysis will consi ...

The following information was available spot rate for

The following information was available: Spot rate for Japanese yen: $0.009313 730-day forward rate for Japanese yen: $0.010475 (assume a 365-day year) U.S. risk-free rate: 7.0 percent Japanese risk-free rate: 1.0 percen ...

Explain the difference between a short hedge and a long

Explain the difference between a short hedge and a long hedge ? a. What is the basis? b. How is the basis expected to change over the life of a futures contract? c. Explain why a strengthening basis benefits a short hedg ...

A companys dec 31st year-end balance sheet showed 72000 of

A company's Dec. 31 st year-end balance sheet showed $72,000 of inventory. The company uses the perpetual inventory system. After reviewing the company's records, the auditor noted the following items which had not been ...

1 how much should you pay for a bond that pays a coupon of

1. How much should you pay for a bond that pays a coupon of 7%? The bond has a par value of $1,000 and will mature in 8 years. ( Round to the nearest dollar) 2. Huan Zhang bought a 10-year bond that pays 8.25% compounded ...

1 what is financial leverage why is a one-year measure of

1. What is financial leverage? Why is a one-year measure of return on investment inadequate in determining whether positive or negative financial leverage exists? 2. What is the motivation for a sale-leaseback of the lan ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen