Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Quarter in Coming Year Following Year Sales forecast First $436 Second $348 Third $348 Fourth $396 First Quarter $396 Paymore's labor and administrative expenses
Quarter in Coming Year Following Year Sales forecast First $436 Second $348 Third $348 Fourth $396 First Quarter $396 Paymore's labor and administrative expenses are $77 per quarter and interest on long-term debt is $52 per quarter. Paymore's 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 $348 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 $348. 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 (figures in $ millions) First Second Third Fourth A. Cash requirements Cash required for operations Interest on bank loan Total cash required $ 0.00 SA $ 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 EA $ 0.00 EA $ 0.00
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