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

Financial management project -overview this assignment

Financial Management Project - Overview: This assignment consists of 2 questions covering Bond Valuation and Portfolio Analysis. Question 1: Bond Valuation Let's suppose today is 16/01/2018, and you are observing the inf ...

Assignmentthe purpose of this assignment is to allow you

Assignment The purpose of this assignment is to allow you the chance to evaluate the role of social responsibility in society. After you complete this assignment, you will analyze a written article, be able to ascertain ...

1 analyze marketing opportunities using environmental

1. Analyze marketing opportunities using environmental scanning market data, measurement, and analysis. 2. Explain issues pertaining to marketing environment both internally and externally 3. Demonstrate an understanding ...

Please respond to the followinga as a financial manager

Please respond to the following: a) As a financial manager, determine at what point the risk of an investments outweighs the potential reward. Provide support for your rationale. b) Explain whether or not you believe an ...

Question spirituality is a fundamental and universal

Question : Spirituality is a fundamental and universal aspect of human existence and is a critical component in working with clients, groups, communities, etc. There is a vast diversity in spiritual beliefs and religious ...

In a long essay of 1500 words you must reflect on the

In a long essay of 1,500 words, you must reflect on the Palliser Furniture cases. Please answer the following three questions: Palliser Furniture Ltd. Palliser Furniture Ltd.: The China Question Questions : What were Pal ...

Part aweek 1in order to properly implement a strategic plan

Part A Week 1: In order to properly implement a strategic plan, organizations use structure, various control systems (budgets, variance analysis, policies and procedures, company rules), and culture. Let us revisit Gener ...

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

Portfolio projectexotic food inc capital budgeting casecase

Portfolio Project: Exotic Food Inc., Capital Budgeting Case CASE SUMMARY Exotic Food Inc., a food processing company located in Herndon, VA, is considering adding a new division to produce fresh ginger juice. Following t ...

Assignmentthe interview assignment asks you to perform an

Assignment The interview assignment asks you to perform an informational interview with a professional within the Fitness and Wellness industry. The person does not have to be an owner but simply someone who is or has be ...

  • 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