Accounting principles, Juan's Taco Corporation has

Accounting principles

Reference no: EM1360241

Juan's Taco Company has restauraunts in five college towns. Juan wants to expand into Austin and College Station and needs a bank loan to do this. Mr. Bryan, the banker, will finance construction if Juan can present an acceptable three-month financial plan for January through March. Following are actual and forecasted sales figures:

Actual & Forecast
November $120,000
December $140,000
January $190,000
Februry $210,000
March $230,000
April $230,000

Of Juan's sales, 30% are cash and the remaining 70% are credit. Of credit sales, 40% are paid in the month after sale, and 60% are paid in the second month after the sale. Materials cost 20% of sales and are paid for in cash. Labor is 50% of sales and is also paid in the month of sales. Selling and administrative expense is 5% of sales and is also paid the month of sales. Overhead expense is $12,000 and dividends of $16,000 will be paid in March. Cash at the beginning of January is $70,000 and the minimum desired cash balance is $65,000.

For January, February and March, prepare a schedule of monthly cash reciepts, mothly cash payments, and a complete monthly cash budget with borrowings and repayments.

Reference no: EM1360241

Questions Cloud

Detemine the price for each mri scan : The Sans Roentgen Outpatient MRI Center has asked you to detemine the price to be charged for each MRI scan for the first year of operations. Below is the relevant budget information:

Write c program that prompts for variable number of integers : Write a C program that prompts for a variable number of integers, adds them up, averages them, and prints out the average.

Find the angle of the first order maximum : Find the angle of the first order maximum. what horizontal distance does it travel before it lands on building.

Explain what opportunities are there for established : Explain What opportunities are there for established airlines to improve their competitive position through differentiation strategies?

Accounting principles : Juan's Taco Corporation has restauraunts in five college towns. Juan wants to expand into Austin and College Station and needs a bank loan to do this. Mr. Bryan, the banker,.

Counterproductive work behavior - tools to mitigate : From the e-Activity, determine the five guidelines listed and provide an example of an appropriate tool that might help achieve each guideline.

Find the maximum altitude reached by the rocket : Find the maximum altitude reached by the rocket.Find its total time of flight.

Difference in income between men and women : Determine whether there is a significant difference in income between men and women. what statistical test would you use?

Create a database for a home-budgeting application : The first part is to create a database and some tables which will be appropriate for a home-budgeting application. That portion of the assignment should be completed from the MySQL console command line.

User Account

All Pages