Respond to the following for AirBnB Projected Financial Statements (Income Statement, Balance Sheet and Statement of Cash Flows) for 3 years into the future This must be broken down by year into two (2) columns 1 column without your strategy and 1 column with your strategy The without column should serve as the basis for your with strategy column and only those financial statement accounts that will be changed, based on your strategy, should be impacted Include Projected ratios for the without and with strategy by year Discuss how these ratios compare and contrast with the historical findings Cost Analysis completed on an Excel tab that outlines the cost that will be incurred to implement the strategy This information should correspond with the With Strategy on the Projected Financial Statements, linking of cells to the financial statements is encouraged Net Present Value analysis of proposed strategys new cash flow you may also use Excel to solve for this From the income statement the change in operating income between your with and without strategy should serve as your cash inflow for each year NOTE To construct the first cash flow (cf 1 ) the new revenue from your strategy(s) must be discounted back to the present value by calculating EBIT (Operating Income on the Income Statement) and that figure will be your cf n for each year cf 0 (initial cost of your strategy), cf 1 (discounted cash flow first year), r (opportunity cost of capital, the rate of the next best alternative use of cash debt equity resources)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 21, 2024

Respond to the following for AirBnB: Projected Financial Statements (Income Statement, Balance Sheet and Statement of Cash Flows) for 3 years into the future. This

Respond to the following for AirBnB:

Projected Financial Statements (Income Statement, Balance Sheet and Statement of Cash Flows) for 3 years into the future. This must be broken down by year into two (2) columns: 1 column without your strategy and 1 column with your strategy. The without column should serve as the basis for your with strategy column and only those financial statement accounts that will be changed, based on your strategy, should be impacted.
Include Projected ratios for the without and with strategy by year. Discuss how these ratios compare and contrast with the historical findings.
Cost Analysis completed on an Excel tab that outlines the cost that will be incurred to implement the strategy. This information should correspond with the With Strategy on the Projected Financial Statements, linking of cells to the financial statements is encouraged.
Net Present Value analysis of proposed strategys new cash flow you may also use Excel to solve for this. From the income statement the change in operating income between your with and without strategy should serve as your cash inflow for each year. NOTE: To construct the first cash flow (cf₁) the new revenue from your strategy(s) must be discounted back to the present value by calculating EBIT (Operating Income on the Income Statement) and that figure will be your cf_n for each year. cf₀ (initial cost of your strategy), cf₁ (discounted cash flow first year), r (opportunity cost of capital, the rate of the next best alternative use of cash/debt/equity resources).