Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The financial staff at Safe-Life Systems, Inc., an alarm systems manufacturer, has estimated the following sales and other expense figures for the second half of

image text in transcribed

The financial staff at Safe-Life Systems, Inc., an alarm systems manufacturer, has estimated the following sales and other expense figures for the second half of 2017. Actual sales in June 2017 were $105,000. The firm sells 60% on cash, it collects 39% of the remainder one month after the sale, and 1% are written off as bad debts. Purchases are estimated to represent 55% of the next month's sales. The firm pays 40% of its purchases in cash and the remainder during the following month. Commissions to sales associates represent 15% of collectable sales, but the firm has decided to include a bonus of 5% more if the sales of the current month are higher than the previous one. Each of the two partners is paid 20% of the average total sales of the previous and current month, plus a 5% bonus if the sales of the current month are higher than the previous one. Monthly wages, rent, and lease expenses are $5,000,$3,000, and $1,500, respectively. The firm has an ending cash balance of $25,000 in June 2017. Create a cash budget for July to December 2017, and determine the firm's ending cash balance in each month if the firm has a required minimum monthly cash balance of $25,000. The partners are considering a line of credit from a commercial bank. Determine the amount that would be necessary to meet the total borrowing needs for July to December 2017 . Round the result to the next highest $10,000. Consider three scenarios. In the first scenario, monthly revenues are 5% better than expected, but cash sales are 40% of forecasted revenue, while credit sales are 58% and 2% are written off as

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

Financial Accounting

Authors: Belverd E Needles, Marian Powers

10th Edition

0547193289, 9780547193281

More Books

Students also viewed these Finance questions

Question

Is the hierarchy of the headings obvious?

Answered: 1 week ago