Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Below you see the income budget for Company Inc. Use the information to fill in the cash flow budget and answer the questions. (20p)

image text in transcribed

Below you see the income budget for Company Inc. Use the information to fill in the cash flow budget and answer the questions. (20p) Beginning cash balance 5 600 . Accounts payable from the previous year 5 750 and accounts receivable from the previous year 8900 . Half of the sales are credit sales with the payment time of 30 days. The other half is in cash. Sales and purchases are divided equally on all the days of the period. NOTE! All months are calculated with 30 days. Payment time for the purchases is 30 days Salaries are 4 500 /month Rent is 2 500 /month In the beginning of the year the company has a bankloan of 25 000 . Interest is payed in March 500 , in September 500 and in December 500. At the same time with paying the interest we amortize the loan with 1 000 . Investments in new machinery is done in January 1 250 and in September 2850 . If we don't have enough money we can get a short-term loan from the bank. Always round up to the next 1000 . The loan is payed back as soon as we have the money. -The owner makes a private withdrawal 1 500 each month. Income budget Sales January-March 36 April-June July-September October-December 48 42 48 Purchase 15,84 21,12 18.48 21,12 Contribution marg 20160 26880 23520 26880 Salaries Rent Depreciation Interest Total fixed costs Budgeted result CASH FLOW BUDGanuary March April-June July-September October-December Beginning cash balance Sales Acc. Receivable Loan (short-term) Total Purchase Acc. Payable Salaries Rest Interest Amortization (long-term) Investments Private withdrawal Amortization (short) Total Net cash flow How much loan does the company have at the end of the year? How much accounts receivable does the company have at the beginning of next year? How much accounts payable does the company have at the beginning of next year?

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

Bond Markets Analysis and Strategies

Authors: Frank J.Fabozzi

9th edition

133796779, 978-0133796773

More Books

Students also viewed these Finance questions

Question

Why are federal government financial reports prepared?

Answered: 1 week ago

Question

Outline two major problems for psychogenic identity theory.

Answered: 1 week ago

Question

Evaluate the integral, if it exists. Jo y(y + 1) dy

Answered: 1 week ago