Estimate Financial Model Parameters (5 marks)

i. In sales-driven spreadsheet models, many items on the Income Statement and

Balance Sheet are a proportion of sales, including (but not limited to):

• Receivables

• Accounts Payable

Determine appropriate forecasts of all relevant sales-related ratios (not just the

two above examples) for Webjet. One method is to plot and analyse the

historical values to obtain forecasts for the next three years. Alternatively,

companies sometimes disclose their own management’s forecasts of financial

ratios. Therefore, if Webjet provides forecasts then you may use these

forecasts in your model. Note: as explained in Question 5 part (i), your

financial model must include some additional line items. Therefore, be sure to

also develop forecasts for these new line items.

ii. There are other parameters that are not a ratio of sales, such as:

• Depreciation

• Interest expense

• Dividends paid

Determine appropriate forecasts for non-sales-related ratios (not just the three

above examples) for Webjet by examining the historical values or making

reasonable assumptions.

4. Estimate Discount Rate and Perpetual Growth Rate (3 marks)

To value Webjet from the free cash flows, you need to estimate the weighted

average cost of capital (WACC) and the long-run free cash flow growth rate

(see Benninga Sections 3.4 and 3.5).

i. You will first need to estimate the cost of equity. If you use the CAPM you

must state the values and the source for each variable. Beta may be obtained

from a reliable source, or you may estimate your own value. Similarly, explain

how you calculate the cost of debt.

ii. Estimate Webjet’s WACC.

iii. Read Benninga section 3.4 on the long-run free cash flow growth rate. What is

your estimate of this figure for Webjet? You must explain how you obtained

your estimate

i. In sales-driven spreadsheet models, many items on the Income Statement and

Balance Sheet are a proportion of sales, including (but not limited to):

• Receivables

• Accounts Payable

Determine appropriate forecasts of all relevant sales-related ratios (not just the

two above examples) for Webjet. One method is to plot and analyse the

historical values to obtain forecasts for the next three years. Alternatively,

companies sometimes disclose their own management’s forecasts of financial

ratios. Therefore, if Webjet provides forecasts then you may use these

forecasts in your model. Note: as explained in Question 5 part (i), your

financial model must include some additional line items. Therefore, be sure to

also develop forecasts for these new line items.

ii. There are other parameters that are not a ratio of sales, such as:

• Depreciation

• Interest expense

• Dividends paid

Determine appropriate forecasts for non-sales-related ratios (not just the three

above examples) for Webjet by examining the historical values or making

reasonable assumptions.

4. Estimate Discount Rate and Perpetual Growth Rate (3 marks)

To value Webjet from the free cash flows, you need to estimate the weighted

average cost of capital (WACC) and the long-run free cash flow growth rate

(see Benninga Sections 3.4 and 3.5).

i. You will first need to estimate the cost of equity. If you use the CAPM you

must state the values and the source for each variable. Beta may be obtained

from a reliable source, or you may estimate your own value. Similarly, explain

how you calculate the cost of debt.

ii. Estimate Webjet’s WACC.

iii. Read Benninga section 3.4 on the long-run free cash flow growth rate. What is

your estimate of this figure for Webjet? You must explain how you obtained

your estimate

Assessment 2- Short answer questions (Total – 30%)Please answer the following questions.1. If you suspect an older person has altered cognition, what five (5) actions would you take and why would you undertake...Assessment Task 3: Reflective JournalThis is a Personal Reflective Evaluation, describing your own leading and managing capabilities with a resulting personal development plan. This should be concise....MGT 314 ASSIGNMENTPart 1 - from Mid 2 syllabus1 Fit Fut Garments factory experienced a sudden spike in defects last month The data below shows defects for the months of March and April This is a major...You are required to write an academic essay to demonstrate proficiency in the language and literacy demands of academic writing. The topic chosen will require you to examine and critically evaluate an...All managers use computers and different types of software to make rational decisions. Can computers be a better alternative for manager's creativity and intuitive judgement while making decisions?...All managers use computers and different types of software to make rational decisions. Can computers be a better alternative for manager's creativity and intuitive judgement while making decisions?...Dynamic Modelling, Screen Design andTest Plan1. TIMELINES AND EXPECTATIONSDue date: Monday, Week 11, 11:55pm Weighting: 20%, maximum mark: 100.Minimum time expectation: 40 hours [4 out of the 40 hours...**Show All Questions**