Ask Financial Management Expert

The Balance Sheet of Company A on December 31 last year is shown below. The company has received a large order and anticipates the need to go to the bank to increase its borrowings. As a result, it has to forecaset its cash requirements for January, February and March this year. Typically, the company collects 20 per cent of its sales in the month of sale, 70 per cent in the subsequent month, and 10 per cent in the second month after the sale. All sales are credit sales. Cash 50,000 Accounts Payable 360,000 Accounts Receivable 530,000 Notes Payable 400,000 Inventories 545,000 Accrued Expenses 212,000 Current Assets 1,125,000 Current Liabilities 972,000 Long-term Liabilities 450,000 Non-Current Assets 1,836,000 Total Liabilities 1,422,000 Common Stocks 100,000 Retained Earnings 1,439,000 Total Assets 2,961,000 Total Liabilities & Shareholders' Equity 2,961,000 Purchases of raw materials to manufacture the company's products are made in the month prior to the sale and amount to 60 per cent of sales in the subsequent month. Payments for said purchases occur in the month after the purchase. Labor costs, including overtime, are expected to be P150,000 in January, P200,000 in February, and P160,000 in March. Selling, administrative, and other cash expenses are expected to be P100,000 per month for January through March. Actual Sales in November and December last year and projected sales for January through April this year are as follows: November 500,000 February 1,000,000 December 600,000 March 650,000 January 600,000 April 750,000 Required: 1. Prepare a cash budget for the months of January, February and March taking into consideration that the firm wants to maintain a cash balance of P50,000 at all times. 2. Prepare a projected Income Statement for the months of January, February and March. 3. Prepare a projected Balance Sheet as of March 31. 

Financial Management, Finance

  • Category:- Financial Management
  • Reference No.:- M91944818

Have any Question?


Related Questions in Financial Management

Assignment problems1 on the day harry was born his parents

Assignment Problems 1. On the day Harry was born, his parents put $1600 into an investment account that promises to pay a fixed interest rate of 5 percent per year. How much money will Harry have in this account when he ...

1 activities of a company that require the spending of cash

1) Activities of a company that require the spending of cash are known as: A) Uses of cash. B) Cash on hand. C) Cash receipts. D) Sources of cash. E) Cash collections. 2) Relationships determined from a firm's financial ...

Module discussion forumto prepare for this discussion

Module : Discussion Forum To prepare for this discussion, review "Basics of Speechwriting" and "Basics of Giving a Speech" in textbook Chapter 15. Then watch this video of Apple founder and CEO Steve Jobs giving the 2005 ...

Launching a new product linefor this portfolio project

Launching a New Product Line For this Portfolio Project Option, you will act as an employee in a large company that develops and distributes men's and women's personal care products. The company has developed a new produ ...

Question 1 discuss valuing bonds and how interest rates

Question : 1) Discuss valuing bonds and how interest rates affect their value. Also consider the importance of the yield-to-maturity (YTM). 2) Discuss common stocks and preferred stocks. Also, which common stock valuatio ...

Introductionlast week you determined the root causes of the

Introduction Last week, you determined the root cause(s) of the problem you are trying to resolve for your final paper. As a reminder, the decision you are working on is the one that you selected in week two. This week, ...

You have owned and operated a successful brick-and-mortar

You have owned and operated a successful brick-and-mortar business for several years. Due to increased competition from other retailers, you have decided to expand your operations to sell your products via the Internet. ...

You will be conducting an interview with a market research

You will be conducting an interview with a market research professional or a company representative. Use the results of your research to make specific recommendations on how market research can be applied to the Marketpl ...

Question 1 what is marketing research what are the two

Question 1: What is marketing research? What are the two primary types of research? Question 2: What factors influence marketing research? Question 3: The role of statistics in business decision-making? Assignment : Sele ...

Chapter 74 for commercial banks what is meant by a managed

Chapter 7 4. For commercial banks, what is meant by a managed liability? What role do liquid assets play on the balance sheet of commercial banks? What role do money market instruments play in the asset and liability man ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As