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

  Targeted operating income

Nichols Company has a selling price of $150 per unit, variable costs $90 per unit and total fixed costs of $300,000. The number of units that Nichols Company must sell to reach targeted operating income of $90,00 is:

  Speculating with currency futures

Speculating with Currency Futures: Suppose that a March futures contract on Mexican Peso was available in January for $.09 per unit. Also suppose that forward contracts were available for same settlement date at a price of $0.092 per peso.

  Length of the firm cash conversion cycle

For the Cook County Company, the average age of accounts receivable is 60 days, the average age of accounts payable is 45 days, and the average age of inventory is 72 days. Assuming a 365-day year, what is the length of the firm's cash conversion ..

  Company repayment and coupons

In 30 years, what will your company's repayment be if you issue the coupon bonds? What if you issue the zeroes?

  Give the simple entry for explanation

Show me the assumption and give the simple entry for explanation

  Describes the forms of substantiation a taxpayer

Which section of the IRC describes the forms of substantiation a taxpayer must maintain in order to claim valid business-related entertainment expense deductions?

  Annual financial statements for the stockholders

NITSU Manufacturing Corporation is preparing the annual financial statements for the stockholders. A statement of cash flows must be prepared. The following data on cash flows were developed for the entire year ended December 31, 2009:

  What is needles basis in the machinery

Nora transfers to Needle Corp depreciable machinery originally costing $18,000 and now having a $15,000 adjusted basis. In exchange, Nora receives all 100 shares of Needle stock having an $18,000 FMV and a three-year Needle note having a $4,000 FM..

  Narrative form the flow of direct materials

Explain in narrative form the flow of direct materials, direct labor, and factory overhead costs through the ledger accounts.

  Calculate the amount of net income reported on xyz company

Calculate the amount of net income reported on XYZ Company's 2011 income statement. Do not use decimals in your answer.

  Journalize the treasury stock transactions

During 1st year of operations Klump Corporation had the following transactions pertaining to its common stock.

  Opening the mail and recording payments

Which of the following should be performed by the persons opening the mail and recording payments?

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