Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Actual sales in November and December 2017 were $375,000 and 266,667 , respectively. Sixty percent of sales are on credit. The firm collects 60% of

image text in transcribed
Actual sales in November and December 2017 were $375,000 and 266,667 , respectively. Sixty percent of sales are on credit. The firm collects 60% of these credit sales during the first after the sale and the remainder during the following second month. Purchases constitute 60% of the next month's sales. The company pays 50% during the first month after the purchase was made and the remainder in the next month. Wages, taxes and other expenses are expected to be 30% of forecasted sales. A major capital expenditure of $70,000 is expected in March. Interest payments are expected to be $30,000 every month and the company needs a minimum cash balance of $25,000. The beginning cash balance is $30,000. Using the provided simple cash budget example similar to what we did in class, help the finaneial staff of Precise Speed Inc., to prepare their cash budget for January to June 2018. Use an interest rate of 9% for any borrowings: Actual sales in November and December 2017 were $375,000 and 266,667 , respectively. Sixty percent of sales are on credit. The firm collects 60% of these credit sales during the first after the sale and the remainder during the following second month. Purchases constitute 60% of the next month's sales. The company pays 50% during the first month after the purchase was made and the remainder in the next month. Wages, taxes and other expenses are expected to be 30% of forecasted sales. A major capital expenditure of $70,000 is expected in March. Interest payments are expected to be $30,000 every month and the company needs a minimum cash balance of $25,000. The beginning cash balance is $30,000. Using the provided simple cash budget example similar to what we did in class, help the finaneial staff of Precise Speed Inc., to prepare their cash budget for January to June 2018. Use an interest rate of 9% for any borrowings

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

The Complete Guide To Real Estate Finance For Investment Properties

Authors: Steve Berges

1st Edition

0471647128, 978-0471647126

More Books

Students also viewed these Finance questions

Question

Azure Analytics is a suite made up of which three tools?

Answered: 1 week ago