State the maximum funds available to be invested

Assignment Help Financial Accounting
Reference no: EM132972873

Question - Below is the sales forecast, in dollars, for the upcoming year for Houseware Store. Houseware store collects 15% of each month's sales in cash, 49% one month later, and 32% the second month after the sale. 4% of sales are bad debt. A given month's purchases are 60% of the forecasted sales amount for that month and 15% of the previous months sales forecast( ¼ of materials are bought for cash, the other ¾ are paid on "net 30 terms"). The other cash flows for JUNE through AUGUST are $35 interest income to be received in JUNE, a principal repayment of $30 in JULY, interest payment of $50 in JUNE, tax payments of $80 in AUGUST, cash proceeds from asset sale of $65 in AUGUST, and payment for asset acquisitions of $45 in JULY. The company's policy mandates that a minimum of $150 be kept in cash at all times. Ending cash in MAY is projected to be $215, and the company has no outstanding short-term borrowing or investments at that time.

Month Sales Forecast

January $45

Feb. 48

Mar. 50

Apr. 52

May 63

Jun. 59

July 76

Aug. 83

Based on this information, prepare cash forecast for JUNE through AUGUST using the cash receipts and disbursements method.

Interpret your forecast. State the maximum funds available to be invested over this period, and the maximum funds needed to be borrowed.

Reference no: EM132972873

Questions Cloud

What would be the effect of accepting the special order : If X is currently operating at 90% capacity, what would be the effect of accepting the special order to the operating income of X
What is the intial cost of the building : Payments were made as follows: January 2 - 1,500,000; April 1 - 2,000,000; June 1 - 2,100,000; October 1 - 1,700,000; What is the intial cost of the building
Calculate the net present value : The property value of $1,000,000 is expected to grow by 2% per year from the time it is built. If Hu has a discount rate of 6%, calculate the Net Present Value
What amount of gain must be recognized on this transaction : What amount of gain must be recognized on this transaction? They are both actively employed as Chicago Public School teachers
State the maximum funds available to be invested : Interpret your forecast. State the maximum funds available to be invested over this period, and the maximum funds needed to be borrowed
How much of maple''s taxable income is apportioned to state a : Maple Corporation realized $1.5 million of taxable income from the sales of its products in States A and B. How much of Maple's taxable income
What is the amount of the consolidated net income : On July 1, 20x6, there was a downstream sale of equipment at a gain of P25,000. What is the amount of the consolidated net income
Calculate both as distributed as dividends and as salary : Ken and has asked you whether it would be better to distribute the money as a dividend or salary. Calculate both as distributed as dividends and as salary
Google documentary managing organizational behavior : Google Documentary Managing Organizational Behavior. Write the elements you have observed as it relates to organizational behavior from google.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Prepare a classified balance sheet

Prepare a classified balance sheet that includes the correct balance for Cash.

  Find the arr with annual depreciation

Find the 1.) PBP, 2.) ARR, with annual depreciation of 14,000, 3.) NPV, and 4.) IRR. 5.) Should the equipment be bought? Explain.

  What net cash flow from operating activities was

What net cash flow from operating activities was? Amortization of premium on bonds payable $500. Decrease in accounts payable $5,000

  What are qualitative factors should consider as an analyst

What are the qualitative factors you should consider as an analyst when evaluating a company's likely future financial performance? Why?

  Diversified rentals ltd owns a large fleet of different

diversified rentals ltd owns a large fleet of different vehicles which are each classified into one of three categories

  Kiddo company manufactures

Kiddo Company manufactures and ships children's stuffed animals across the nation

  Determine relationship between shareholders and stakeholders

Determine relationship between shareholders and stakeholders. Which of the arrangements for a Rs.1,000 CD yields the largest terminal (future) value?

  Income statement effects for the accumulated depreciation

Sin City Entertainment owns a number of casinos in Las Vegas and has decided to expand to Atlantic City. Prepare the entries to report the following activity, and show how this activity changes Sin City’s 2015 year-end financial statements. List the ..

  Actually produced what is the expected total costs

In a period when anticipated production is 10,000 units budgeted variable costs are 85,000 and budgeted fixed costs are 45,000. if 12,000 units are actually produced what is the expected total costs.

  Calculate the percentage return for this project

An investment in production equipment will cost the company $268,403 and will return equal annual cash flows of $40,000 for the next 10 years. Using the Internal Rate of Return (IRR) method, calculate the percentage return for this project.

  Describe the two forms of account receivable confirmation

Identify and describe the two forms of account receivable confirmation requests and indicate what factors Adem should consider in determining

  How much would be willing to pay for one share

UPS preferred stock pays $4. If your required rate of return is 8.44 percent, How much would you be willing to pay for one share if this preferred stock?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd