Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

both answers are important. if you can provide the numeric answers please. thanks! PROBLEM 2, a Use the Ch 15 Problems Spreadsheet in Files on

both answers are important. if you can provide the numeric answers please. thanks!
image text in transcribed
image text in transcribed
PROBLEM 2, a Use the Ch 15 Problems Spreadsheet in Files on Canvas, Tab: Problem 2 to answer the question. James Buchanan Orthotics and Prosthetics is planning to request a line of credit from its bank. The company has produced sales estimates, and these appear in the worksheet below. Collection estimates are as follows: 10 percent within the month of sale, 75 percent in the month following the sale, and 15 percent in the second month following the sale. Labor and supplies estimates also appear in the worksheet below. Payments for labor and supplies are typically made during the month following the one in which these costs have been incurred. General and administrative salaries will amount to approximately $27,000 a month; lease payments under long-term lease contracts will be $9,000 a month; depreciation charges will be $36,000 a month; miscellaneous expenses will be $2,700 a month; income tax payments of $63,000 will be due in both September and December; and a progress payment of $180,000 on a new building must be paid in October. Cash on hand on July 1 will amount to $132,000, and a minimum cash balance of $90,000 will be maintained throughout the cash budget period. What loan will be the company require in September? Ignore interest expenses. (Write the loan amount as a positive number.) Question 4 2 pts PROBLEM 2, b Following the previous question, what will be the company's cumulative surplus cash or loan balance at the end of January? PROBLEM 2, a Use the Ch 15 Problems Spreadsheet in Files on Canvas, Tab: Problem 2 to answer the question. James Buchanan Orthotics and Prosthetics is planning to request a line of credit from its bank. The company has produced sales estimates, and these appear in the worksheet below. Collection estimates are as follows: 10 percent within the month of sale, 75 percent in the month following the sale, and 15 percent in the second month following the sale. Labor and supplies estimates also appear in the worksheet below. Payments for labor and supplies are typically made during the month following the one in which these costs have been incurred. General and administrative salaries will amount to approximately $27,000 a month; lease payments under long-term lease contracts will be $9,000 a month; depreciation charges will be $36,000 a month; miscellaneous expenses will be $2,700 a month; income tax payments of $63,000 will be due in both September and December; and a progress payment of $180,000 on a new building must be paid in October. Cash on hand on July 1 will amount to $132,000, and a minimum cash balance of $90,000 will be maintained throughout the cash budget period. What loan will be the company require in September? Ignore interest expenses. (Write the loan amount as a positive number.) Question 4 2 pts PROBLEM 2, b Following the previous question, what will be the company's cumulative surplus cash or loan balance at the end of January

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

Foundations of Financial Management

Authors: Stanley Block, Geoffrey Hirt, Bartley Danielsen, Doug Short, Michael Perretta

10th Canadian edition

1259261018, 1259261015, 978-1259024979

More Books

Students also viewed these Finance questions

Question

home work help

Answered: 1 week ago