Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please post the answers complete, thank u in advance. You are the manager of El Yunque Inn. You would like to pay all your employees

Please post the answers complete, thank u in advance.
image text in transcribed
You are the manager of El Yunque Inn. You would like to pay all your employees a Christmas bonus totaling $10,000 Your owner, Don Papo agrees with your incentive rewards but wants to make sure the Inn will generate enough cash flow in December to pay the $10,000 and still maintain a minimum $5,000 cash balance Based on the following information, prepare a cash budget to determine whether or not you can afford to pay your employees their Christmas bonus, which will be $10,000 in total October November December Credit Sales $ 60,000.00 $ 80,000.00 $ 75,000.00 75% collected in next month $ 45,000.00 $ 60,000.00 $ 56,250.00 25% collected in two months $ 15,000.00 $ 20,000.00 $ 18,750.00 Cash Sales $ 12,500.00 $ 16,390.00 $ 20,590.00 Credit Purchases-paid next month Cash Purchases $ 30,560.00 $ 34,580.00 $ 28,650.00 Cash Purchases $ 3,116.00 $ 2,159.00 $2,489.00 Payroll --35% of total sales $ 25,375.00 $ 33,736.50 $ 33,456.50 Service on mortgage per month $5,000.00 Insurance-prepaid every 3 months $ 3,000.00 Property tax-due in November $ 15,000.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Inside Company Valuation

Authors: Angelo Corelli

1st Edition

3319537822, 9783319537825

More Books

Students also viewed these Finance questions

Question

1. Always guess when only right answers are scored.

Answered: 1 week ago