Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Income Statement Data: $26 million in EBITDA is distributed as follows: January through April: 5% each month May and June: 10% each month July and

Income Statement Data:

$26 million in EBITDA is distributed as follows:

January through April: 5% each month

May and June: 10% each month

July and August: 15% each month

September and October: 10% each month

November and December: 5% each month

Depreciation is $1 million per month

Interest Expense is $6 million per year

The combined state and federal tax rate is 35%

Timing Adjustments:

Annual interest expense consists of $3 million bond interest payments due on March 15 and September 15.

Annual licensing fees of $2.4 million are due on July 1

Annual liability insurance premium of $6 million is due on September 1

Quarterly real estate tax payments of $1.8 million are due on February 1, May 1, August 1, and November 1 ($7.2 million in total).

Investing and Financing Cash Flows:

$5 million bond principal repayments are due on February 1 and August 1 ($10 million for year).

$6 million in restaurant renovations are paid in equal monthly installments

Maintenance capital expenditures are $750,000 per month ($9 million for year).

The theme park would like to pay dividends of $2 million per quarter on March 15, June 15, September 15, and December 15 ($8 million in total).

image text in transcribed

THEME PARK 2016 PROJECTED MONTHLY CONDENSED CASH FL (S in Millions) Jan Feb Mar Jun Jul Se Oct Nov Dec Total Condensed Income Statement EBITDA Depreciation Expense Interest Expense Pre-Tax Income Income Tax (Provision) Be Net Income nefi Timing/Non-Cash Adjustments Add Back Depreciation Expense Interest Expense (Semi-Annual) Licensing Fee (A Insurance (Annual) Real Estate Taxes (Quartery) Operating Cash Flow Investing/Financing Cash Flows Bond Principal Repayment Restaurant Renovations Maintenance Capital Expenditures Monthly Cash Flow Surplus (Deficit) Cumulative Surplus (Deficit)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions