Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

4. Prepare a cash budget for Puerto 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 Puerto 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. a. PREFG had sales of $ 3,000,000 in August and $ 4,500,000 in September. The company predicts sales of $1,000,000, $ 1,500,000 and $2,000,000 for October, November and December 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 receive other interest income of $ 50,000 from marketable securities in December. b. Considering sales forecasts as detailed in Part a, 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 a financial manager) 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 paid at the end of the quarter. New equipment costing $600,000 will be purchased and paid for in December. . . 5

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

Financial Reporting Financial Statement Analysis And Valuation

Authors: James M Wahlen, Stephen P Baginskl, Mark T Bradshaw

10th Edition

0357722094, 978-0357722091

More Books

Students also viewed these Finance questions

Question

4.3 Describe the job analysis process and methods.

Answered: 1 week ago