Question: Hi, Can you please help me for find : -DCF -NPV -IRR -CACGR Project Valuation Discount rate Tax rate Year # Investment Revenue Opex EBIT

Project Valuation Discount rate Tax rate Year # Investment Revenue Opex EBIT

Hi,

Can you please help me for find :

-DCF

-NPV

-IRR

-CACGR

After-Tax EBIT cm wc Reinvestments Free Cash Flow Discount factors Discounted Free

Project Valuation Discount rate Tax rate Year # Investment Revenue Opex EBIT After-Tax EBIT cm wc Reinvestments Free Cash Flow Discount factors Discounted Free Cash Flow IRR CAGR year Capital Budgeting Plan Assum Ions 12% 34% 2018 -2 800 ooo -2 800 ooo -2 800 ooo 2019 400 ooo Assignment: 2020 2 1 500 ooo 2021 3 3 ooo ooo 2022 4 4 600 ooo 2023 6 6 ooo ooo Compute Sum of dicounted Free Cash Flow (DCF), Net Present Value of Free Cash Flow, and Internal Rate of Return (IRR) using following assumptions: 1 - Investment : 2 800 000 2 - Discount rate : 12% 3 - Revenue : see figures from Yl to Y5 4 - Opex : 30% of revenue 5 - Tax rate: 34% 6 - Changes in Net Working Capital: 15% of revenue Additional questions: 1- what is CAGR in revenue from YI to Y5? 2- what is NPV if 150 000 reinvested in Y3?

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 Accounting Questions!

Requirements from this case. Please answer. 1. We can mix EAS and Lighting investment but should not cross the $7M capital. 2. We need to run trial and error run to find the most savings within the...

Project #2 This time we won't go through the spreadsheet step by step. You are given the assumptions and you must complete the projections on your own. 1. Projecting cash flows. Complete the cash...

Hi Tutor, Can you please help my assignment below. Hi Please Use excel to solve this assignment and have to use excel to actually calculate numeric results, nevertheless to show the procedure used,...

I need help doing these 10 problems, please help! Question 1 Consider the following mutually exclusive investments 1 2 Investment A: -100 20 120 Investment B: -100 100 31.25 Find IRRs for both...

hello For this milestone, submit a draft of the Time Value of Money section of the final project, along with your supporting explanations. Base your calculations on the data provided in this case...

or this milestone, submit a draft of the Time Value of Money section of the final project, along with your supporting explanations. Base your calculations on the data provided in this case study:...

hello For this milestone, submit a draft of the Time Value of Money section of the final project, along with your supporting explanations. Base your calculations on the data provided inthis case...

hello i have an assignement and i need help. For this milestone, submit a draft of the Time Value of Money section of the final project, along with your supporting explanations. Base your...

Ch5&6 Case Study - Capital Budgeting The company is looking at developing a new robot that not only folds boxes but can be adjusted to do any size boxes. This represents the first attempt at entering...

Hi, please provide detailed solution for these two questions. Thank you. RSM 333 Spring 2017 Assignment #2 Due Monday, February 6th @ 4pm in Commerce Office Problem #1: (20 marks) Project Analysis /...

Consider the system in Figure. 1. Assume that X c (j?) = 0 for |?| ? ? / T and that denotes an ideal lowpass reconstruction filter. 2. The D/A converter has a built-in zero-order-hold circuit, so...

Contrast the following terms: a. Static extract; incremental extract b. Data scrubbing; data transformation c. Consolidation; federation d. ETL; master data management

Use power series operations to find the Taylor series at x = 0 for the x 2 1 - 7 x The Taylor series for 1 1 - x is a commonly known series. What is the n = 0 , ( Type an exact answer. ) 1 1 3 I...

Russia has recently started a push for stronger smoking regulations, much like those in Western countries, concerning cigarette advertising, smoking in public places, and so on. The webfile named...

Indicate whether the following independent transactions increase (+), decrease (), or do not affect (NE) the current ratio, the amount of working capital, and cash from operations. Also indicate the...

If you were trying to assess the financial health of a government administered pension plan, which financial statements or schedules would you review and why?

Mack Banta, a nonexempt account representative, worked extra hours this week as a call operator. A number of operators were out for the week and Banta was asked to pick up some of their hours. Can...

The Excel worksheet form that follows is to be used to recreate the Review Problem relating to Ferris Corporation that was presented earlier. Download the workbook containing this form from Connect....

A pointer holds a memory address.

8. Give an example of how the scarcity principle can be used to influence others.

2. A Soviet invasion of Poland would lead to the severing of diplomatic relations between the United States and the Soviet Union.

1. Diplomatic relations between the United States and the Soviet Union would be severed in 1993 than that