N. Flow & Co. has identified the following
N. Flow & Co. has identified the following payment pattern for revenues: 35% of sales are for cash, 15% are received one month after the sale, 50% are received two months after the sale, and bad debt is negligible. Assume today is December 31. Sales for the last three months and sales projections for the next six months are:
N. Flow & Company Sales ($Thousands) | ||||||||||
Row | Column: | D | E | F | G | H | I | J | K | L |
4 | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | |
5 | Sales | 350 | 800 | 1200 | 250 | 300 | 375 | 400 | 500 | 250 |
. . . | ||||||||||
42 | Acct Rec | 420 | 695 | 1180 |
Type a spreadsheet equation that forecasts N. Flow’s Accounts Receivable (row 42) for Jan, such that the equation can also be copied into future months. Your equation will go into cell G42, and MUST BE EXACT—including ALL algebraic and special characters, numbers, letters, etc. Hint: it starts with =.
Copy your formula and paste it into the answer box, such that I can copy and paste it into my spreadsheet, and then copy it across.
-
Rating:
/5
Solution: N. Flow & Co. has identified the following