Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Paula's Planning reported the following Budgeted Income Statement for the months of July, August, September and October, 2013. Note that July 2013 was the first
Paula's Planning reported the following Budgeted Income Statement for the months of July, August, September and October, 2013. Note that July 2013 was the first month of the company's existence, and that the owner deposited $5,000 on July 1 into the company's bank account to get things started. a. Calculate and forecast for Paula's Planning cash availability (for September to December) given the following information. b. Please compare each month's EBIT figure with the ending cash balance. Are they the same? Why or why not? July August September October Revenue Conference $47,900 $ 48,400 $ 49,880 $ 51,200 Revenue Catering $22,500 $21,900 $26,010 $30,080 Cost of sales $19,110 $18,392 $18,954 $19,456 Gross Profit $21,900 $24,684 $25,439 $26,112 Cleaning Supplies + Equipment Depreciation Expense Linen Rental Expense $5,898 $5,921 $5,740 $5,962 Paper Supplies Expense $1,230 $1,630 $1,780 $1,600 Earnings Before Interest + Tax . Of the Conference Revenue, 40% is received in the current month and the remainder is received in the following month. Of the Catering Revenue, 100% is received in the current month . . . Of the cost of sales, 80% is paid in the current month and the remainder is paid in the following month Of the Cleaning Supplies Expense, 100% is paid in the current month Linen, and paper expenses are paid the month they are incurred. Depreciation expense is $300 per month
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