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

  1. 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.
  2. 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.
  3. Now suppose that Paymores other expenses are $109 a quarter. Calculate the expected net cash flow for each quarter in the coming year.
  4. 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

I will post all questions for reference but i need help with

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!