Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

4. Prepare a cash budget for Porto Rico Food Franchise Group (PRFFG, owners of Krispy Kreme franchisee in Puerto Rico among others food franchise) for

image text in transcribed
4. Prepare a cash budget for Porto Rico Food Franchise Group (PRFFG, owners of Krispy Kreme franchisee in Puerto Rico among others food franchise) for the last three months of the year, based on the following information 2. PRFFG had sales of $ 3.000.000 in August and $ 4,500,000 in September. The company predicts sales of $ 1.000.000, $ 1.300.000 and $ 2,000,000 for October. November and Descraber respectively. Based on past experience the company estimates that 60% of sales are cash, while 40% are collected in the next month (following the sale). PRFFG also recive other interest income of $ 50.000 from marketable securities in December Considering sales forecasts as detailed in Parta. PRFFG needs a cash disbursement schedule for the months comprising sales forecasts. The company made purchases of $3,500,000 and $ 2.000.000 in August and September respectively. The company predicts purchase of $500,000 $750,000 and $1.000.000 for October, November and December respectively. In addition, the company has gathered the following information for you as timarscial managery to prepare a cash disbursement schedule for October, November and December 40% of purchases are made in cash. 60% of purchases are paid for one month after purchase. Wages and salaries are 15% of the previous month's sales. Lease payment of $ 100,000 per month A payment of principal and interest of $150,000 is due in December Cash dividend of $50,000 will be paid at the end of the quarter New equipment costing $600,000 will be purchased and paid for in December e PRFFG has a cash balance $100.000 for October and desire to maintain a minimum cash balance of $ 200,000 for unexpected events. With this information and the data obtained in part b, prepare a cash budget for the last quarter (October, November an

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

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

Recommended Textbook for

Computer Accounting With QuickBooks Online

Authors: Donna Kay

3rd Edition

1264127278, 9781264127276

More Books

Students also viewed these Accounting questions