Question: FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 8 1. Retrieve the file HWChapter8ValueDrivers. Do not modify the fonts, format, cell addresses, or organizational design displayed

FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 8 1. Retrieve the

file HWChapter8ValueDrivers. Do not modify the fonts, format, cell addresses, or organizational

FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 8 1. Retrieve the file HWChapter8ValueDrivers. Do not modify the fonts, format, cell addresses, or organizational design displayed in the worksheet file. Values in boldface in the Inputs section display changes from scenario #1 in Chapter 8. 2. Part A reports information regarding Scenario #4 in Chapter 8. Refer to Cells A10:B16 and A20:B24 and apply this information to solve for the values in Cells C20:G24 and B27:B29. Assume there are 50 shares of common stock. Lastly, in Cell A32 display the exact equation used to solve for the value in Cell B27 1 Value Driver Scenarios, Chapter8 Scenario #4 Better Capital Utilization 3 Part A 4 9 Inputs 10 Sales growth in 1 st year 11 |Sales growth in 2nd year 12 Sales growth in 3rd year 13 Long-term sales growth (gl.) 14 Operating profitability (OP) 15 Capital requirement (CR) 16 Cost of capital (WACC 17 18 Scenario #4 19 20 Net sales 21 NOPAT 22 Total net operating capital 23 FCF=NOPAT-Capital 24 ROIC=NOPAT / Capital 25 26 Results 27 Value of operations (Vop) 28 Intrinsic stock price 29 Return on capital (ROIC 30 31 Calculation of Vop, Scenario 4: 32 10.00% 8.00% 7.00% 5.00% 6.00% 52.00% 10.97% Actual Year 1 Year 2 Year 3 Year 4 Year 5 5,000.0 300.0 3,050.0 -260.0 9.84% Scenario #4 FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 8 1. Retrieve the file HWChapter8ValueDrivers. Do not modify the fonts, format, cell addresses, or organizational design displayed in the worksheet file. Values in boldface in the Inputs section display changes from scenario #1 in Chapter 8. 2. Part A reports information regarding Scenario #4 in Chapter 8. Refer to Cells A10:B16 and A20:B24 and apply this information to solve for the values in Cells C20:G24 and B27:B29. Assume there are 50 shares of common stock. Lastly, in Cell A32 display the exact equation used to solve for the value in Cell B27 1 Value Driver Scenarios, Chapter8 Scenario #4 Better Capital Utilization 3 Part A 4 9 Inputs 10 Sales growth in 1 st year 11 |Sales growth in 2nd year 12 Sales growth in 3rd year 13 Long-term sales growth (gl.) 14 Operating profitability (OP) 15 Capital requirement (CR) 16 Cost of capital (WACC 17 18 Scenario #4 19 20 Net sales 21 NOPAT 22 Total net operating capital 23 FCF=NOPAT-Capital 24 ROIC=NOPAT / Capital 25 26 Results 27 Value of operations (Vop) 28 Intrinsic stock price 29 Return on capital (ROIC 30 31 Calculation of Vop, Scenario 4: 32 10.00% 8.00% 7.00% 5.00% 6.00% 52.00% 10.97% Actual Year 1 Year 2 Year 3 Year 4 Year 5 5,000.0 300.0 3,050.0 -260.0 9.84% Scenario #4

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!

FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 4 1. Retrieve the file HWChapter4 and solve Problem 4-21, using the organizational design displayed in the worksheet file Do...

FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 6 1. Retrieve the file HWChapter6 and solve Problem 6-12 using the organizational design displayed in the worksheet file. Do...

FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 4 1. Retrieve the file HWChapter4 and solve Problem 4-4, Problem 4-6, and Problem 4-8, Problem 4-17, Problem 4-19, and Problem...

FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 11 1. Retrieve the file HWChapter1l and solve Problem 11-2, Problem 11-3 and Problem 11-7 using the organizational design...

FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 2 1. Retrieve the file HWChapter2 and solve Problem 2-8, Problem 2-10, and Problem 2-12 using the organizational design...

FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 7 1. Retrieve the file HWChapter7 and solve Problem 7-10, using the organizational design displayed in the worksheet file. Do...

FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 4 1. Retrieve the file HWChapter4 and solve Problem 4-17, Problem 4-19, using the organizational design displayed in the work...

FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT Chapter 4 1. Retrieve the file HWChapter4 and solve Problem 4-4, Problem 4-6, using the organizational design displayed in the...

'1 A C D E F G H Learning Objectives 1. Understand how to use EXCEL Spreadsheet (a) Develop proforma Income Statement Using Excel Spreadsheet (b) Compute Net Project Cashflows, NPV, and IRR (c)...

FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 1. Retrieve the file HWChapter7 and solve Problem 7-14 using thee organizational design displayed in the worksheet file. Do...

The finance director of Toy plc has been asked by a shareholder to explain items that appear in the current cost statement of comprehensive income for the year ended 31.8.20X9 and the statement of...

Reduce the block diagram shown in the figure below to a transfer function, T(s)=C(s)/R(s) R(s) + 50 C(s) s+ 1 2

Meg wants to sell her rental beach home and purchase rental property in the mountains. Her friend, Ryan, tells her he can do a nonsimultaneous tax - free exchange as long as the fair market value of...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

1. We include here a pictorial representation of this chapter in the form of a mind map ( Figure 1.1 ). Use the key words we have included to refresh your memory of what we have covered in this...

1. In what ways is information technology being used by HR professionals?

2. In what ways is information technology being used by line managers?