Question: Please answer this question using excel so I can see the calculations. Project Evaluation [LO1] Dog Up! Franks is looking at a new sausage system

Please answer this question using excel so I can see the calculations.

Project Evaluation[LO1]Dog Up! Franks is looking at a new sausage system with an installed cost of $540,000. This cost will be depreciated straight-line to zero over the projects five-year life, at the end of which the sausage system can be scrapped for $80,000. The sausage system will save the firm $170,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $29,000. If the tax rate is 34 percent and the discount rate is 10 percent, what is the NPV of this project?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Suppose that a firm has borrowed $510,000 in the current year at 7.5% interest rate, with a commitment to repay the loan (principal and interest) in equal annual instalments over the following 7...

pose the project requires time. You will save $130.000 before taxes per year in order processing costs, and you will be able to reduce working capital by $60,000 (this is a one-time reduction). If...

Ch. 9: Questions 7&8 (Questions and Problems section) 7. Calculating IRR [LO5]A firm evaluates all of its projects by applying the IRR rule. If the required return is 14 percent, should the firm...

Hello, Please can someone tell me how to calculate the break even point on Chapter 11 Question 7. Please see the attached. Thank you, Cindy Chapter 9 Question 7 Calculating IRR [LO5] A firm evaluates...

ng at setting up a ten The company bought using it as a warchou bese facilities from net S4.1 will is land: the plant will rth of grading before unt to use as the initial 20.000 motor homes PROBLEMS...

13. Project Evaluation [LO1] Dog Up! Franks is looking at a new sausage system with an installed cost of $560,000. This cost will be depreciated straight-line to zero over the project's five-year...

my question is Q13, projected evaluation, thank you so much! 1000 and is me. The asset is to be used Jull, the asset can be sold for $192.000. If Werdent, what is the aftertax cash flow from the sale...

My question is Q9, calculating projected OCF, thank you so much ! Il asset that costs $730,000 and is 10 Zero over its eight-year tax life. The asset is to be used vear project; at the end of the...

relevant tax rate is 35 percent, what is the aneras casrmow nour une sare C 8. Calculating Salvage Value [L01] An asset used in a four-year project falls in the five-year MACRS class for tax...

Just the highlighted question needs to be checked, the others I've already taken care of with ease, but this one stumped me. pose the project requires time. You will save $130.000 before taxes per...

Problem 10-15 Project Evaluation [LO1] Dog Up! Franks is looking at a new sausage system with an initial cost of $440,000 that will last for five years. The fixed asset will qualify for 100 percent...

Draw ray diagrams that show how three images of an object are formed in two plane mirrors at right angles, as shown in Fig. 23.27a. Figure 23.27b shows a similar situation from a different point of...

The numbers of hours some college students spend watching television during the summer are described by the density histogram in Fig. 94. a. Compute the area of each of the five bars in the density...

Find d d x ( - 4 x 4 3 - 2 x - 3 4 3 ) . Provide your answer below: d d x ( - 4 x 4 3 - 2 x - 3 4 3 ) =

1. Which of the following does the U.S. GAAP not consider to be an objective of segment reporting? a. It helps users better understand the enterprises performance. b. It helps users better assess the...

Luna Company accepted credit cards in payment for $6,000 of services performed during July 2018. The credit card company charged Luna a 4 percent service fee; it paid Luna as soon as it received the...

Ultra Day Spa provided $120,000 of services during 2018. All customers paid for the services with credit cards. Ultra submitted the credit card receipts to the credit card company immediately. The...

On May 1, 2018, Benz's Sandwich Shop loaned $10,000 to Mark Henry for one year at 6 percent interest. Required Answer the following questions: a. What is Benz's interest income for 2018? b. What is...

During the first year of operation, 2018, Direct Service Co. recognized $290,000 of service revenue on account. At the end of 2018, the accounts receivable balance was $46,000. For this first year in...

Create a 200 word summary on the Juvenile Justice System than and today. Describe The Juvenile system and provide a generalizable definition. Highlight the issues in the Juvenile system and why this...

Assess Ille contention that people in Ille third world should learn from the errors of the West and seek development without pollution. Should there be uniform, global environmental standards, or...

Even though they will probably be hit hardest by it, poor nations are less able than are rich countries to deal with the consequences of global warming. As a resul~ do rich nations owe to it to...

Are environmentalists right to be concerned about the environmental impact of SlNs? How do you explain the demand for ever larger passenger vehicles? Will higher gas prices change that?