Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 25, 2024

Hello, Please assist me on the question regarding WACC, Cash Flow, Terminal Value, Final Value Calculation. Please see below and show calculations in excel: TheXYZCompany.earned$10millionbeforeinterestandtaxesonrevenueof$60millionlastyear.Investmentinfixedcapitalwas$12million,anddepreciationwas$8million.Workingcapitalinvestmentwas$3million.Thecompanyexpectssales,EBIT,investmentinfixedandworkingcapital,depreciationtogrowat12%peryearforthenextfiveyears.Afterthat,thegrowthwilldeclinetoastable4%peryear,andinvestmentsinfixedassetswilloffsetdepreciation.ThecompanysWACCis8%.Whatisafairvalueofthecompany?[Cashflows,terminalvalueinYear6,finalvaluecalculation]

Hello,

Please assist me on the question regarding WACC, Cash Flow, Terminal Value, Final Value Calculation. Please see below and show calculations in excel:

TheXYZCompany.earned$10millionbeforeinterestandtaxesonrevenueof$60millionlastyear.Investmentinfixedcapitalwas$12million,anddepreciationwas$8million.Workingcapitalinvestmentwas$3million.Thecompanyexpectssales,EBIT,investmentinfixedandworkingcapital,depreciationtogrowat12%peryearforthenextfiveyears.Afterthat,thegrowthwilldeclinetoastable4%peryear,andinvestmentsinfixedassetswilloffsetdepreciation.ThecompanysWACCis8%.Whatisafairvalueofthecompany?[Cashflows,terminalvalueinYear6,finalvaluecalculation]

Thank you!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

Step: 3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Precalculus

Authors: Michael Sullivan

9th edition

321716835, 321716833, 978-0321716835

Students also viewed these Finance questions

Question

★★★★★

On September 10, Melinda Johnson was auditing the financial statements of a new audit client, Mother Earth Foods, a health-food chain that has a June 30 year-end. The company is privately held and...

Answered: 1 week ago

Question

★★★★★

Review the findings of humanistic psychotherapy outcome research.

Answered: 1 week ago

Question

★★★★★

The Bishop Company has a balance in the warranty obligation account of $400,000. An analysis of the products sold under warranty indicates that a balance of $900,000 should be adequate for this...

Answered: 1 week ago

Question

★★★★★

ABC irketi widget'lar retmektedir. Biten son ay iin, orijinal planlama bteleri, 2.000 para yapacaklarna dair bir varsaym ieriyordu. Her bir widget 100$'a satlyor. Her widget'n aadaki standart...

Answered: 1 week ago

Question

★★★★★

The Bank of Canada accepts deposits from Select one: the general public. chartered banks only. the government of Canada and chartered banks. the Board of Directors.

Answered: 1 week ago

Question

★★★★★

Complete the given JavaScript code in the window.onload event handler below, adding the following functionality to all unordered list elements: when the mouse moves over the element, your code...

Answered: 1 week ago

Question

★★★★★

Q2 Based on your graphical and numerical analysis in Q1, which method -- 1.5(IQR) or 3(SD) -- is more appropriate to remove outliers from the `departure delay` variable? Remove outliers for...

Answered: 1 week ago

Question

★★★★★

Imagine you are halfway through a project and there will be a 50% audit conducted externally on your project. 1. Imagine you are the project manager and you know that this audit is coming. What would...

Answered: 1 week ago

Question

★★★★★

ASSIGNMENT: For this assignment, you will serve in the hypothetical role of HR Specialist and external consultant who is tasked with developing a performance evaluation strategy for the job on which...

Answered: 1 week ago

Question

★★★★★

this final course assignment, you are going to assemble all elements of your hypothetical business that you have been working on throughout the course into one thoughtfully planned portfolio. This...

Answered: 1 week ago

Question

★★★★★

A health system has forecast net patient revenue in the first 3 months of the year as follows (figures in millions: January, $200. February, $140 March, $200. 70% of services are usually paid for in...

Answered: 1 week ago

Previous Question Next Question