Question
Can anyone help me using formulas in excel please. The Right Target, Inc., a marketing research and consulting firm, is working on a cash budget
Can anyone help me using formulas in excel please.
- The Right Target, Inc., a marketing research and consulting firm, is working on a cash budget for July to December 2017. The staff has projected the following cash collections and payments:
| Month | Collections | Payments | |||
| Cash Sales | Credit Sales | Purchases | Wages | Miscellaneous Expenses | |
| July | $10,000 | $20,000 | $15,000 | $6000 | $1,500 |
| August | $12,000 | $24,000 | $18,000 | $7,200 | $2,000 |
| September | $14,000 | $28,000 | $21,000 | $8,400 | $2,500 |
| October | $16,000 | $32,000 | $24,000 | $9,600 | $3,000 |
| November | $20,000 | $40,000 | $30,000 | $12,000 | $4,000 |
| December | $25,000 | $50,000 | $37,500 | $15,000 | $4,500 |
- If the ending cash balance as of June 30, 2017 was $10,000, determine the firms forecasted monthly cash balance.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Public Finance
Authors: Harvey Rosen, Ted Gayer
10th edition
9781259716874, 78021685, 1259716872, 978-0078021688
