P11.3 You have the following information about a restaurant:BudgetedCash RevenueBudgetedCredit RevenueAugustSeptemberOctober$30,30029,50027,90025,10032,400$16,00014,00013,00012,00015,800NovemberDecemberCollections on credit revenue average 90% in the month following thesales and the remaining 10% in the month following. Cost of sales (pur-chases) averages 38% of total sales revenue. Forty percent of cost of salesis on a cash basis, and 60% is paid in the month following purchase. Pay-roll costs (which are paid on a cash basis) are forecast to be $13,100 forOctober; $12,700 for November; and $12,200 for December.Other budgeted expenses according to the forecast income state-ments follow:OctoberNovemberDecember$2,500300Rent expense$2,500$2,500300300Insurance expenseUtilities expenseOther operating costsDepreciation (equipment)Interest expense5004505500064,6001,1001,3004,6004,600400400400 Note that the rent, utilities, other operating costs, and interest are paid in cash eachmonth as the expense is incurred. The insurance expense is paid in January each yearin advance for the whole year ($3,600). The restaurant financed its equipment andmakes monthly payments on the balance owing (principal amount) of $1,000. InDecember, the restaurant plans to sell off some old equipment and estimates it willreceive $1,500 from the sale. At the same time, it must spend $5,400 on newequipment. If there is sufficient cash on hand, the owner plans to pay a bonus to thestaff. This bonus will amount to $3,600 and will be paid in December. Prepare therestaurant's cash budget for each of the three months: October, November, andDecember. The beginning cash balance October 1 is $2,410.

Cash Budget is an estimation of Cash receipts and payments of a specific period.

Note that the rent, utilities, other operating costs, and interest are paid in cash each month as the expense is incurred. The insurance expense is paid in January each year in advance for the whole year ($3,600). The restaurant financed its equipment and makes monthly payments on the balance owing (principal amount) of $1,000. In December, the restaurant plans to sell off some old equipment and estimates it will receive $1,500 from the sale. At the same time, it must spend $5,400 on new equipment. If there is sufficient cash on hand, the owner plans to pay a bonus to the staff. This bonus will amount to $3,600 and will be paid in December. Prepare the restaurant's cash budget for each of the three months: October, November, and December. The beginning cash balance October 1 is $2,410.

Note that the rent, utilities, other operating costs, and interest are paid in cash each month as the expense is incurred. The insurance expense is paid in January each year in advance for the whole year ($3,600). The restaurant financed its equipment and makes monthly payments on the balance owing (principal amount) of $1,000. In December, the restaurant plans to sell off some old equipment and estimates it will receive $1,500 from the sale. At the same time, it must spend $5,400 on new equipment. If there is sufficient cash on hand, the owner plans to pay a bonus to the staff. This bonus will amount to $3,600 and will be paid in December. Prepare the restaurant's cash budget for each of the three months: October, November, and December. The beginning cash balance October 1 is $2,410.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

In October, a store offers the public a "Buy Now Pay Later" sales plan. With this plan, Mrs. Hernández acquires a hair straightener, which she receives on November 1, and which she must pay in 12 monthly installments of $ 55.5 as of January 1 of the following year. If you consider an interest of 55% annually convertible monthly. What is the cash value of the furniture?
Mr. Harrington had a new heating system installed in his office. The balance owing to the heating company is $40,000 which includes equipment and installation fees. The heating company has agreed to let him make individual payments on the account whenever he’d like, but the final balance must be paid two years (24 months) from now. Starting today, interest will accumulate on the balance at 3.45% compounded monthly. Mr. Harrington will make a payment of $8000 4 months from now and $6000 19 months from now. What is the final balance owing on the account in two years (24 months from now)?
Lucky Strike, a bowling alley, purchased new equipment from Brunswick in the amount of $850,000. Brunswick is allowing Luck Strike me to amortize the cost of the equipment with monthly payments over 2 years at 12% interest. What equal monthly payment will be required to amortize this loan?
A logo design company purchases four new computers for $16,500. The company finances the cost of the computers for 3 years at an annual interest rate of 4.175% compounded monthly. Find the monthly payment (in dollars) for this loan. Round your answer to the nearest cent.
Please Answer with Explanation complesari
After two years in business, the owners have saved (have a surplus of) $123,750.00. They must decide if they will invest in property or investment bonds. If they invest in a property and a vehicle, the total cost will be $445,500,00, of which $123,750.00 will be required as a down payment. The fixed interest rate on the mortgaged amount is 5.40% compounded semi-annually for a term of 13 years. 5. What is the size of the semi-annual payments required to settle this mortgage? 6. What is the size of the final payment? 7. How long would it take (in months) to settle this loan with regular monthly payments of exactly $2000 instead of the PMT value calculated in Part 5?
A couple bought a business to rent apartments near St Clair's College in North York. They purchased it for $800,000. They made a down payment of 30% of the value of the rental business and received the rest of the purchase price in a 25-years amortized mortgage from Royal Bank Canada. The interest rate was 5.80% compounded semi-annually and the payments were at the end of each month. The interest rate was fixed for a 3-year term. a) What is the amount of down payment? What was the amount left to be amortized over the 25 years? b) How many payments are there over the 25-year amortization? c) What would be the monthly periodic interest rate be? d) Calculate the monthly payment amount.
A property in Waterford was purchased with a down payment of $3525 and payments of $2025 at the beginning of every 6 months for 9 years. interest is 6% compounded monthly. what were the purchase price of the property and the cost of financing?
Apple has purchased land for $500,000 for their new factory. They make a down payment of $100,000, and the remainder is financed at (15) percent compounded semi-annually with semi-annual payments over 4 years. Develop an Excel® table to illustrate the payment amounts and schedule for the loan, assuming payback follows a) Plan 1: Pay the accumulated interest at the end of each interest period and repay the principal at the end of the loan period. b) Plan 2: Make equal principal payments, plus interest on the unpaid balance at the end of the period. c) Plan 3: Make equal end-of-period payments. d) Plan 4: Make a single payment of principal and interest at the end of the loan period. e) A different plan: Pay off the principal in such a way that it is X, 1.5X, 2X, 2.5X... till the end of the last payment period. In addition, pay the accumulated interest at the end of each interest period.
Mr. Harrington had a new heating system installed in his office. The balance owing to the heating company is $24,000 which includes equipment and installation fees. The heating company has agreed to let him make individual payments on the account whenever he’d like, but the final balance must be paid two years (24 months) from now. Starting today, interest will accumulate on the balance at 3.80% compounded monthly. Mr. Harrington will make a payment of $7000 4 months from now and $8000 18 months from now. What is the value of i (the periodic interest rate)? a. 0.001583 b. 1.900000 c. 0.009500 d. 0.003167
Lens Care Inc. (LCI) manufactures specialized equipment for polishing optical lenses. There are two models - one mainly used for fine eyewear (F-32) and another for lenses used in binoculars, cameras, and similar equipment (B-13).The manufacturing cost of each unit is calculated using activity-based costing, using the following manufacturing cost pools: Cost Pools Allocation Base Costing Rate Materials handling Number of parts $ 2.40 per part Manufacturing supervision Hours of machine time $ 14.80 per hour Assembly Number of parts $ 3.30 per part Machine setup Each setup $ 56.50 per setup Inspection and testing Logged hours $ 45.50 per hour Packaging Logged hours $ 19.50 per hour LCI currently sells the B-13 model for $1,775 and the F-32 model for $1,220. Manufacturing costs and activity usage for the two products are as follows: B-13 F-32 Direct materials $ 164.50 $ 75.60 Number of parts 160 120 Machine hours 7.90 4.20…
A credit card company offers an annual 2% cash back rebate on all gasoline purchases. If a family spent 6200$ on gas purchases over the course of a year, what was the family's rebate at the end of the year?