Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter which has been provided in the below table.

Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter which has been provided in the below table.

Quarter in Coming Year Following Year
First Second Third Fourth First Quarter
Sales forecast $372 $360 $336 $384 $384

Paymores labor and administrative expenses are $65 per quarter and interest on long-term debt is $40 per quarter. Paymores cash balance at the start of the first quarter is $40 and its minimum acceptable cash balance is $30. Assume that Paymore can borrow up to $100 from a line of credit at an interest rate of 2% per quarter. On average, one-third of sales are collected in the quarter that they are sold, and two-thirds are collected in the following quarter. Assume that sales in the last quarter of the previous year were $336. On average, two-thirds of purchases are paid for in the quarter that they are purchased, and one-third are paid in the following quarter. Prepare a short-term financing plan using the above table. (Leave no cells blank. Enter '0' when necessary. Negative amounts should be indicated by a minus sign. Do not round intermediate calculations. Enter your answers in millions of dollars rounded to 2 decimal places.)

Quarter
(figures in $ millions) First Second Third Fourth
A. Cash requirements
Cash required for operations
Interest on bank loan
Total cash required $0.00 $0.00 $0.00 $0.00
B. Cash raised in quarter
Line of credit
Total cash raised $0.00 $0.00 $0.00 $0.00
C. Repayments of bank loan
D. Addition to cash balances
E. Line of credit
Beginning of quarter
End of quarter 0.00 0.00 0.00 0.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbooks In Operations Research And Management Science Financial Engineering Volume 15

Authors: John R. Birge , Vadim Linetsky

1st Edition

0444517812, 0080553257, 9780444517814, 9780080553252

Students also viewed these Finance questions

Question

Explain the factors influencing wage and salary administration.

Answered: 1 week ago

Question

Examine various types of executive compensation plans.

Answered: 1 week ago

Question

1. What is the meaning and definition of banks ?

Answered: 1 week ago

Question

2. What is the meaning and definition of Banking?

Answered: 1 week ago