Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Jim Daniels Hoaith Products has eight stores. The firm wanss to expand by two more stores and needs a bank loan to do this. Mr.

image text in transcribed
image text in transcribed
Jim Daniels Hoaith Products has eight stores. The firm wanss to expand by two more stores and needs a bank loan to do this. Mr. Howitt, the banker, wit france construction if the firm can present an acceptoble three-month financial plain for January through March. Following are actual and ferecasted sales Squres: Of the firmis sales, 30 percent are for cash and the remainang 70 percent are on credi, Of credit sales, 20 percent are paid in the month after sale and 80 percent are paid in the second month afier the sale. Materials cost 30 percent of sales and are purchased and received each manth in an amount wufficient to cover the curtent month's expected salos. Materials are paid for in the month they are recelved. Labour expense is 40 percent of sales and is paid in the montr of sales. Seting and administrative expense is 88 percent of sales and is also poid in 15 month of soles: Overhead is $30,500 in cash per month anortirabon expense is $10,500 per month. Takes of $8,500 will be paid in January and dimidends of $4,500 wil be psid in March. Cash st the beginning of January is $90.000 and the minimint desired cash balance is $85.000 a. Prepare a schedule of monthily cash receipts for January. February and March b. Prepare a schedule of monthy cash payments for January. February and March. c. Prepare a schedule of monthly cash budget with borrowings and repayments for January. February and March. (Do not leave any empty spaces; input a O wherever it is required. Negative answers and amounts to be deducted should be indicated by a minus sign.)

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

CISA Certified Information Systems Auditor Study Guide

Authors: David L. Cannon, Timothy S. Bergmann, Brady Pamplin

1st Edition

0782144381, 978-0782144383

More Books

Students also viewed these Accounting questions