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 $484 $343 $354 $402 $402 Paymores labor and administrative expenses are $83 per quarter and interest on long-term debt is $58 per quarter. Paymores cash balance at the start of the first quarter is $40 and its minimum acceptable cash balance is $44. Assume that Paymore can borrow up to $354 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 $354. 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. Round order, payment, and collection calculations to the nearest whole number. Enter your answers in the Table in millions of dollars, rounded to 2 decimal places. image text in transcribed

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. Following Year First Quarter $402 First $484 Quarter in Coming Year Second Third $343 $354 Fourth $402 Sales forecast Paymore's labor and administrative expenses are $83 per quarter and interest on long-term debt is $58 per quarter. Paymore's cash balance at the start of the first quarter is $40 and its minimum acceptable cash balance is $44. Assume that Paymore can borrow up to $354 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 $354. 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 'O' when necessary. Negative amounts should be indicated by a minus sign. Round order, payment, and collection calculations to the nearest whole number. Enter your answers in the Table in millions of dollars, rounded to 2 decimal places.) Quarter Second First Third Fourth (figures in $ millions) A. Cash requirements Cash required for operations Interest on bank loan Total cash required B. Cash raised in quarter $ 0.00 $ 0.00 $ 0.00 S 0.00 Line of credit 0.00 $ 0.00 $ 0.00 $ 0.00 Total cash raised 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

Lectures On Public Economics

Authors: Anthony B. Atkinson, Joseph E. Stiglitz

1st Edition

0691166412, 978-0691166414

More Books

Students also viewed these Finance questions