Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

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

Discussion question find an example of a document that

Discussion Question : Find an example of a document that misuses graphics. This can be a document that you have received (please blot out any sensitive information and names) or a document that you find on the Internet. ...

1 identify one cyberattack that occurred in the last 2

1. Identify one cyberattack that occurred in the last 2 years. What caused the cyberattack? Do not repeat an example that has been posted previously. 2. How did the cyberattack impact data loss, financial loss, cleanup c ...

Part 1 conduct internet research sources must be documented

Part 1. Conduct Internet research, (sources must be documented using MLA format), and write a brief analysis of the current status of the U.S. economy. Include current values and trends for at least three of the followin ...

Conduct preliminary research on the 2008 lehman brothers

Conduct preliminary research on the 2008 Lehman Brothers Bankruptcy and its various effects on world financial markets, business management, the credit crisis and individual wealth. Your research and resulting reviews sh ...

Choose a publicly traded company to value in preparation

Choose a publicly traded company to value in preparation for a purchase by ABC Company (a fictitious company who has unlimited funds for this purchase). While ABC Company has the funds to purchase the selected company, A ...

Management control systems and national cultures and

Management Control Systems and National Cultures and Corporate Social Responsibility o What steps, if any, is Amazon taking to be sensitive to the national culture. o What is Amazon doing with regard to Corporate Social ...

Grounded theory and ethnography assignment instructionseach

Grounded Theory and Ethnography Assignment Instructions Each qualitative design is slightly different from the others; these differences are important for researchers to consider when selecting a design that is most appr ...

Watch the video role morality link attached below in the

Watch the Video: Role Morality (Link attached below in the documnet) And answer the following questions: 1. Do you agree that a person should have one set of morals for family and church and another set for his or her em ...

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 ...

Time value 21 gronkrobkowski has asked your help in

Time Value 2 1. GronkRobkowski has asked your help in deciding between two contract offers made by the Patriots.  The first is a four year contract with a $10 M signing bonus today, and salaries starting next year for $1 ...

  • 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