Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

The management estimates total sales for the period January through June based on actual sales from the immediate past six months. The following assumptions are

The management estimates total sales for the period January through June based on actual sales from the immediate past six months. The following assumptions are made: 1. The Sales were $150,000 in January 2018 and then the sales grew by 10% each month for the first five months (February to June). The sales are expected to grow by 5% each month thereafter. 2. 50% of the Sales are collected in the same month. 45% of the sales are collected in the following month and remainder are not collected. 3. The Purchases are 20% of sales and paid in the same month. 4. Wages and Salaries are $10,000 each month and paid in the same month. 5. Depreciation expense is $5,000 each month. 6. An equipment worth $100,000 will be purchased with cash in October. 7. The company's debt is $50,000 and the company pays coupon payments in June and December of each year. The coupon rate is 10% per year. 8. Rent Expenses will be $5000 and will be paid at the end of each calendar quarter. Determine the cash surplus and shortages for each month from July to December.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Elasticity Theory Applications And Numerics

Authors: Martin H. Sadd Ph.D.

4th Edition

0128159871, 978-0128159873

Students also viewed these Finance questions