Prepare a schedule of monthly cash receipts

Assignment Help Accounting Basics
Reference no: EM13257532

Juan's Taco Company has restaurants in five collegetowns. Juan wants to expand into Austin and College Stationand needs a bank loan to do this. Mr. Bryan, the banker, willfinance construction if Juan can present an acceptable three-monthfinancial plan for January through March. The following are actualand forecasted sales figures:

Actual

Forecast

AdditionalInformation

November $120,000

January $190,000

Aprilforecast   $230,000

December    140,000

February 210,000



March     230,000


Of Juan's sales, 30 percent are for cash and the remaining70 percent are on credit. Of credit sales, 40 percent are paid inthe month after sale and 60 percent are paid in the second monthafter the sale. Materials cost 20 percent of sales and are paid forin cash. Labor expense is 50 percent of sales and it'spaid in the month of sales. Selling and administrative expense is 5percent of sales and is also paid in the month of sale. Overheadexpense is $12,000 in cash per month; depreciation expense is$25,000 per month. Taxes of $20,000 and dividends of $16,000 willbe paid in March. Cash at the beginning of January is $70,000 andthe minimum desired cash balance is $65,000.

For January, February, and March, prepare a schedule of monthly cash receipts, monthly cash payments, and a complete monthly cashbudget with borrowings and repayments.

Reference no: EM13257532

Questions Cloud

What will the market price of the security : The market price of a security is $55. Its expected rate of return is 9.26%. The risk-free rate is 4.26%, and the market risk premium is 5.26%. Assume the stock is expected to pay a constant dividend in perpetuity.
What are the power loss in the armature and the power input : A permanent magnet DC motor has an armature resistance of 0.45 ohm and when a voltage of 120 V is applied to the motor it reaches a steady-state speed of rotation of 25 rev/s and draws 35 A.
Determine the rotational inertia of a meter stick : Calculate the rotational inertia of a meter stick, with mass 0.83 kg, about an axis perpendicular to the stick and located at the 44 cm mark
Explain what is the final volume of oxygen gas : A syringe containing 1.55ml of oxygen gas is cooled from 95.3C to 0.0C. What is the final volume of oxygen gas
Prepare a schedule of monthly cash receipts : For January, February, and March, prepare a schedule of monthly cash receipts, monthly cash payments, and a complete monthly cashbudget with borrowings and repayments.
To help overcome communication barriers : To help overcome communication barriers, after you receive a message: Answer check for the feelings related to the message. take the message at face value to avoid communicating distrust.
How to presented the leadership team : which must be presented to the leadership team (cite the theoretical process chosen/reviewed)? Thoroughly explain each step of your plan.
What is the per-share value of the companys common stock : What is the per-share value of the company's common stock?
If the string is vibrating in fifth harmonic how long is it : The wave function of a certain standing wave on a string fixed at both ends is y(x,t) = 0.30 sin(0.0025x)cos(300t) where y and x are in centimetres and t is in seconds. If the string is vibrating in its fifth harmonic, how long is it

Reviews

Write a Review

Accounting Basics Questions & Answers

  Determining contribution deduction

Prior to a charitable gift to the Plato University of land with a basis of $6,000 and a value of $13,000, All-Set, Inc. had taxable income of $50,000. If the dividends-received deduction was $80,000, the charitable contribution deduction is:

  Problem on performing managerial services

Bart transfers land used in his business (held as an investment for 3 years) worth $165,000 (basis of $100,000) and performs managerial services worth $15,000, in return for 30 shares in AB Corp.

  Understanding of financial ratios

Now that Bob has a better understanding of financial ratios, he's anxious to begin comparing last year's performance with this year'sperformance. What initial advice should Mark offer?

  How much can she deduct

Although her records of the expenses incurred in the breeding activity are spotty, she can establish that in year 10 she spent $1,000 on transportation and lodging to attend cat shows, $400 on cat food, $700 on veterinary expenses, and $300 on gro..

  What is the annual net cash inflow

Linda wants to use the $236,100 proceeds ($168,000 + $19,000 + $49,100 = $236,100) from sale of the securities to open a retail store under a 12-year franchise contract.

  Bond issue and interest accrued on bonds due adjustment

Show the journal entries in 2006. (Please be reminded the year-end for ABC Corporate is Dec 31, adjusting is required)

  Manufacture a product income

A company can sell all the units it can produce of either Product A or Product B but not both. Product A has a unit contribution margin of $16 and takes two machine hours to make and Product B has a unit contribution margin of $30 and takes three ..

  Record the bond pruchase on august 1, 2010

On August 1, 2010, Dambro Co acquired 200, $1,000, 9% bonds at 97 plus accrued interest. The bonds will be added to Dambro's available for sale portfolio. The bonds were dated May 1, 2010, and mature on April 30, 2016, with interest paid each October..

  Statement of cash flow by using direct method

Prepare a statement of cash flow using the direct method for reporting cash flows from operating activities. Omit supporting schedule

  Question on maturity matching principle

Describe the maturity matching principle. What are the risks of not matching maturities? How would you characterize a firm that ignores the principle? Can you think of situations in which it would be advisable for an otherwise prudent firm to dev..

  Income statements and other pertinent computations

The following data are for the year ended December 31, 20XX:The submission should be 2 to 4 pages and need to include income statements and other pertinent computations in good format as well as a discussion interpreting the analysis. Answer all q..

  What accounts for the investments in accordance with ias 39

Rolling Thunder decided to discontinue its entire wholesale division (a major line of business) and to keep its manufacturing division. On September 15, it sold the wholesale division to Dylane Corp. During 2014, there were 800,000 common shares o..

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