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

In 1803 the us doubled in size with the louisiana purchase

In 1803, the U.S. doubled in size with the Louisiana Purchase. That well-known real estatemogul Napoleon Bonaparte sold us 827,000 square miles (529,280,000 acres-there are 640 acresin a square mile). We paid $15 million ...

Family finance homework regarding automatic millionair

Family finance homework regarding Automatic millionair book Read the book The Automatic Millionaire by David Bach. Turn in a 2-5 page double-spaced paper (3 points). Please do not go over 5 pages. Write one paragraph for ...

Assignment budget planning and controlbefore approaching

Assignment: Budget Planning and Control Before approaching this assignment, be sure that you have watched the following video. Budgetary Planning featuring Babycakes *FULL VIDEO* . (2016). YouTube.  Babycakes, a specialt ...

What are the two major provisions of the mcfadden actwhat

What are the two major provisions of the McFadden Act? What was the motivation behind its passage?

1 rate the following five websites from best to worst for

1. Rate the following five websites from best to worst for finding comparative financial ratio information about a company. Explain. 2. What might you do if you fail to find comparative financial ratio information and ne ...

Again consider the monthly 1-year and 10-year treasury

Again consider the monthly 1-year and 10-year Treasury constant maturity rates from April 1953 to October 2000. Consider the log series of the data and build a VARMA model for the series. Discuss the implications of the ...

Choice of monetary policywhen does the fed use a

Choice of Monetary Policy: When does the Fed use a stimulative monetary policy, and when does it use a restrictive monetary policy? What is a criticism of a stimulative monetary policy? What is the risk of using a moneta ...

You are a group of analysts assisting a head of equities

You are a group of analysts assisting a head of equities provide investment advice for clients. Using at least 2 methodologies available from the following 4 groups: DDM, FCF, Residual Income, Market Based Valuation/Pric ...

Your company doesnt face any taxes and has 769 million in

Your company doesn't face any taxes and has $769 million in assets, currently financed entirely with equity. Equity is worth $51.90 per share, and book value of equity is equal to market value of equity. Also, let's assu ...

An investor wants to buy a bullet bond of the automotive

An investor wants to buy a bullet bond of the automotive sector. He has two choices: either invest in a US corporate bond denominated in euros or in a French corporate bond with same maturity and coupon. Are the two bond ...

  • 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

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate