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

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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