Explore BrainMass

Explore BrainMass

    Application of Accounting Principles - Juan's Taco Company

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    I am stuck and need help with the following problem:
    Problem P4-20 Chapter 4, Block & Hirt, Finance and Accounting 11th edition

    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.

    © BrainMass Inc. brainmass.com October 1, 2020, 8:49 pm ad1c9bdddf

    Solution Preview

    January receipts:
    60% of 70% of November's sales = .6*.7*120000=50400
    40% of 70% of December's sales = .4*.7*140000=39200
    30% of January sales = .3*190000 = 57000
    Total = 146600
    January payments:
    materials = 20% of sales = .2*190000=38000
    labor = 50% of sales = .5*190000=95000
    selling&administrative = 5% of sales = ...

    Solution Summary

    This uses the example of a restaurant to present a three-month financial plan.