Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Unit 8 - Westfield Corporation I need help with the bold and figuring out the numbers for year 11 performa Schedule 10 Proforma Proforma Proforma
Unit 8 - Westfield Corporation I need help with the bold and figuring out the numbers for year 11 performa | ||||||||||||
Schedule 10 | Proforma | Proforma | Proforma | |||||||||
10A. Make a scenario recommendation: | Weight | Year 5 IPO | Year 5 End | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | |||
Reason 1: | Financial Outcomes | |||||||||||
Reason 2: | Margin | 4.031887% | 6.247371% | 611.289500% | 6.795304% | 8.575429% | ||||||
Reason 3: | Asset Utilization | 2.04743206 | 2.15838120 | 2.18437883 | 2.32306671 | 2.21658670 | ||||||
Reason 4: | Return on Assets | 8.26% | 13.48% | 13.35% | 15.79% | 19.01% | ||||||
Reason 5: | WACC | 14.02% | 15.70% | 16.59% | 17.30% | 19.48% | ||||||
0% | Difference ROA-WACC | -5.76% | -2.22% | -3.24% | -1.51% | -0.47% | ||||||
Return on Equity | 15.50% | 21.19% | 18.72% | 15.79% | 19.01% | |||||||
10B. The ability of the company to attract, safisfy, and retain the better customers. | Weight | |||||||||||
Impact 1: | Company Data | |||||||||||
Impact 2: | Price Per Share | $17.142857 | $20.50 | $23.00 | $50.00 | $90.00 | $126.34 | $187.76 | ||||
Impact 3: | Earnings Per Share | $1.4837 | $2.6689 | $2.9821 | $4.1863 | $6.2214 | ||||||
Impact 4: | Price-Earnings Ratio | 15.50 | 18.73 | 30.18 | 30.18 | 30.18 | ||||||
Impact 5: | Market Cap | $8,571,428 | $10,250,000 | $11,500,000 | $25,000,000 | $45,000,000 | $63,171,267 | $93,880,926 | ||||
0% | Shares of Stock | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | 500,000 | ||||
Credit Rating | B | BB | BBB | A | A | BBB | ||||||
10C. The ability of the company to attract and retain the better employees. | Weight | Beta | 1.5 | |||||||||
Impact 1: | ||||||||||||
Impact 2: | ||||||||||||
Impact 3: | ||||||||||||
Impact 4: | ||||||||||||
Impact 5: | ||||||||||||
0% | ||||||||||||
10D. The ability of the company to attract and retain the better stockholders and lenders. | Weight | |||||||||||
Impact 1: | ||||||||||||
Impact 2: | ||||||||||||
Impact 3: | ||||||||||||
Impact 4: | ||||||||||||
Impact 5: | ||||||||||||
0% | ||||||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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