Question: I will post all questions for reference but i need help with question E only! look to the end: calculating Incremental Financing a) Paymore places
I will post all questions for reference but i need help with question E only! look to the end: calculating Incremental Financing
a) Paymore places orders for goods equal to 75% of its sales forecast for the next quarter. What will orders be in each quarter of the coming year if the sales in the current quarter are expected to be $320 and the sales forecasts for the next five quarters are as follows?
| Current Quarter | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | Next year 1st Quarter | |
| Sales | 320 | 379 | 355 | 345 | 335 | 386 |
| orders = 75% sales next quarter | 284.25 | 266.3 | 258.8 | 251.3 | 289.5 |
- Paymore pays for two-thirds of the purchases immediately and pays for the remaining purchases in the next quarter. Calculate Paymores cash payments in the coming year.
- Paymores customers pay their bills with a two-quarter delay. What are the expected cash receipts from sales in the coming year? Assume Paymore began operations in the coming year and so has no sales in periods prior to Q1.
- Now suppose that Paymores other expenses are $109 a quarter. Calculate the expected net cash flow for each quarter in the coming year.
- Suppose that Paymores starting cash balance is $44 and its minimum acceptable balance is $35. Work out the short-term financing requirements for the coming year. (Negative amounts should be indicated by a minus sign. Round your answers to 1 decimal place.)
| Financing needed | Q1 | Q2 | Q3 | Q4 | |
| Opening cash balance | 44.0 | 35.0 | 35 | 35.0 | |
| net cashflow | -381.3 | -370.3 | 16.3 | -30.8 | |
| cash balance | -337.3 | -335.3 | 51.3 | 4.3 | |
| minimum cash balance | 35 | 35 | 35 | 35 | |
| Financing needed | -372.3 | -370.3 | 16.3 | -30.8 | |
| Cumulative Financing | -372.3 | -742.5 | -726.3 | -757.0 | |
| Incremental Financing |

Answer is not complete. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Required E Suppose that Paymore's starting cash balance is $44 and its minimum acceptable balance is $35. Work out the short-term financing requirements for the coming year. (Negative amounts should be indicated by a minus sign. Round your answers to 1 decimal place.) Quarter First Coming Year Second Third (742.5) $ (726.3) Fourth $ $ (757.0) Cumulative financing Incremental financing (372.3) $ (372.3) X $
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
