Utilizing the information provided by Juan Carlos, assist him to determine the monthly cash inflows and needs for his Caf The following table provides a breakdown of the cash inflows and outflows for September through January The September figures are provided, so all you have to do is to place them in the correct row in the chart Credit and cash sales are projected to grow at 10 each month, which can be calculated by simply multiplying the previous months sales figure by 1 1 (26,500 x1 1 29,150) The same calculation can be utilized for increased credit and cash purchases, but instead of multiplying by 1 1, you would multiply by 1 05 to account for the 5 increase Develop a ninety day cash forecast for the Cafe for November, December, and January Assume a beginning cash balance of $5,000 for November (Use the example in the class for Theresas Catering as a guide) Required The first item to consider is the beginning cash balance, which is $5,000 for the Cafe The first major section in the ninety day cash forecast is cash receipts Input the amount of cash sales for November, credit sales for October that were collectable in one month, and credit sales for September that were collectable in two months, and add them to get total cash available The next section, which is cash disbursements, includes all of the cash outflows This section includes cash purchases for November, credit purchases from October that were payable in one month, payroll expenses (32 of monthly sales), monthly debt service payment, and monthly insurance premium payment Now, total the cash disbursements for November w 2015 File Home Colors Working Capital Microsoft Word (Product Activation Failed) View Insert Page Layout References Review Mailings Breaks Indent La Aa Align A Fonts This Di Group Line Numbers Margins Orientation e column Themes Effects Themes Size Columns be Hyphenation Page Setup Spacing Left 0 Before Opt Watermark Page Page Color Borders Right 0 After 10 pt Page Background Paragraph IIIIIIIIIIIII II Position Wrap Text Bring Send Selection Forward Backward Pane Rotate Arrange 1 ''T'X IIIIIIIIIIIII 8 ''T '' ' September October November December January Credit Sales 90 collected in next month 10 collected in two months Cash Sales Credit Purchases paid next month Cash Purchases Payroll32 of total sales Service on Mortgage per Month Monthly Insurance Payment $26,500 23,850 2,650 13 500 16,450 2 345 12 800 6,500 2,000 $29,150 26,235 2,915 14,850 17,273 2,462 14,080 6 500 2,000 $32,065 28 859 3,207 16,335 18 136 2 585 15,488 6 500 2,000 $35,272 31,744 3,527 17,969 19 043 2 715 17,037 6 500 2,000 $38,799 34,919 3,880 19 765 19 995 2 850 18,740 6,500 2,000 O Page 1 of 1 Words 0 English (U S ) 2 E 3 2 100 0 9 e P W EN 4 9 2020

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 17, 2024

Utilizing the information provided by Juan Carlos, assist him to determine the monthly cash inflows and needs for his Caf. The following table provides a

Utilizing the information provided by Juan Carlos, assist him to determine the monthly cash inflows and needs for his Caf. The following table provides a breakdown of the cash inflows and outflows for September through January. The September figures are provided, so all you have to do is to place them in the correct row in the chart. Credit and cash sales are projected to grow at 10% each month, which can be calculated by simply multiplying the previous months sales figure by 1.1 (26,500 x1.1= 29,150). The same calculation can be utilized for increased credit and cash purchases, but instead of multiplying by 1.1, you would multiply by 1.05 to account for the 5% increase

image text in transcribed

Develop a ninety-day cash forecast for the Cafe for November, December, and January. Assume a beginning cash balance of $5,000 for November (Use the example in the class for Theresas Catering as a guide). Required:

The first item to consider is the beginning cash balance, which is $5,000 for the Cafe.
The first major section in the ninety-day cash forecast is cash receipts. Input the amount of cash sales for November, credit sales for October that were collectable in one month, and credit sales for September that were collectable in two months, and add them to get total cash available.
The next section, which is cash disbursements, includes all of the cash outflows. This section includes cash purchases for November, credit purchases from October that were payable in one month, payroll expenses (32% of monthly sales), monthly debt service payment, and monthly insurance premium payment. Now, total the cash disbursements for November.

w 2015 File Home Colors Working Capital - Microsoft Word (Product Activation Failed) View Insert Page Layout References Review Mailings Breaks Indent La Aa Align A Fonts This Di Group Line Numbers Margins Orientation e column. Themes Effects Themes Size Columns - be Hyphenation Page Setup Spacing Left: 0 ; Before: Opt Watermark Page Page - Color - Borders Right: 0 . After: 10 pt Page Background Paragraph IIIIIIIIIIIII II!!!! - Position Wrap Text Bring Send Selection Forward - Backward. Pane Rotate Arrange 1 ''T'X IIIIIIIIIIIII !! !!! !!! !!!8 ''T '' ' September October November December January Credit Sales 90% collected in next month 10% collected in two months Cash Sales Credit Purchases-paid next month Cash Purchases Payroll32% of total sales Service on Mortgage per Month Monthly Insurance Payment $26,500 23,850 2,650 13.500 16,450 2.345 12.800 6,500 2,000 $29,150 26,235 2,915 14,850 17,273 2,462 14,080 6.500 2,000 $32,065 28.859 3,207 16,335 18.136 2.585 15,488 6.500 2,000 $35,272 31,744 3,527 17,969 19.043 2.715 17,037 6.500 2,000 $38,799 34,919 3,880 19.765 19.995 2.850 18,740 6,500 2,000 # O Page: 1 of 1 Words: 0 English (U.S.) 2 E 3 2 100% 0 9 e P. W EN . 4/9/2020