Create performa income statement and Balance sheet based on this details.

Hotel room occupancy rates in our Venetian tower are consistently exceeding $90\%.$ Unfortunately, our property constrains our options. So$,$ we are exploring the option of replacing one of our existing $1,014$ room towers with a new $1,600$ room tower. We are estimating the cost of construction at around $$6,400$ million in combined demolition, lost revenue, and construction costs. The plan is to being construction immediately. Construction would take two years.

Once the new suites rational, we forecast the following increases:

Year Occupancy Rate Net Revenue Increase

$00\%0\%$

$110\%6\%$

$260\%36\%$

$370\%42\%$

$480\%48\%$

$585\%51\%$

$670\%42\%$

$740\%24\%$

As the smallest expansion, this planned addition would likely require complete remodeling:

years. At the beginning of year $8,$ we can probably salvage $$400$ million in equipment, but that figure is far less than its expected

book value.

If we proceed with this expansion, we need to be careful about maintaining our operations over the next two years.

Please create a pro$-$forma income statement and balance sheet for the next two years and estimate any additional funds

needed for this expansion.

Additional assumptions:

Assume any salvage, depreciation, lost revenue, and tax effects of the demolition of the former tower are

included in the construction cost.

Revenue increases are relative to this year, before construction, not relative to the previous year...

We expect no new fixed administrative costs associated with the additional rooms.

As real estate, the new suites will fall into the $30-$year depreciation class. We utilize straight$-$line

depreciation so our annual deprecation will increase by $$213$ million. Please do not account for this change

until after the new tower is completed in the second year.

Treat 'current maturities of long$-$term debt' as if it were notes payable.

The cost of the new suites will be spread over two years. Construction will commence immediately and

require a $60\%$ outlay of $$3840$ million. The remaining $40\%,$ or $$2560$ million, will be paid in the following

year.

Dividends will continue to be paid at the same rate as last year.

As required by Nevada gaming laws, we need to keep substantial cash on hand, at least enough to cover allof

our accrued customer liabilities. Maintain a minimum cash$\_$balance.of at least $$4$ billion at all$\_$times.

Note that because of our significant cash holdings, we accrue more interest than we pay. Thus, our net

interest expense is negative $($an income$).$

Assume momentarily that any necessary loans needed to balance cash flows will be in the form of revolving

short$-$term debt.

Note that accounts receivable, net equals accounts receivable, gross less allowance for doubtful accounts