The Towne Motel has 10 rooms and it open year round. It has no food or...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The Towne Motel has 10 rooms and it open year round. It has no food or beverage facilities. We'll assume you would like to achieve a net after-tax income of approximately $3000 for the year, which is a 10% return on equity of $30,000 The division of your budget into planning periods are best defined as May 1 - October 31 and November 1 - April 30 since the Towne Motel is located in a summer tourist area. The factors and trends expected to affect your business. The Towne Motel has been in business for 10 years and you have developed a solid relationship with your repeat gueats. You do not anticipate any major changes in demand by this market. However, a local motor-inn of comparable facilities has just gone out of business. As a result, you feel your annual occupancy should increase by 5%. The local economy is stable. However, you expect a general increase in prices of 8%. Some rooms will require small renovations $1700 will be spent in June and $1300 will be spent in December Your marketing budget is $650 for May-Oct. and $850 for winter season O Administrative and general expenses are estimated at $ 700 for May- Oct. and $650 for Nov - April 2 Estimate Telephone revenues at $1.50 per occupied room night and Other income at 1% of total reveunes. The owners withdrew $2500 semi annually as drawings from the businessand managed to repay $350 monthly in debt to the local bank Occupied Room Nights May - October November - April Double Occupancy factor May-October November - April Room Rates Single Double Room Revenues May - October November - April Projected 1345 1204 2.0 1.3 $20.00 $. 24.00 =E48 054 75% 68% Last Year 1281 1147 2.0 1.3 $18.00 $ 22.00 70% 63% Room Revenues May-October November - April Total Show your calculations PROJECTED # OF OCCUPIED ROOMS 10 x 183 x.75 10 x 182 x .68 May-Oct Nov-Apr B E48 054 Double Differential Formula A Double Rate x # Rooms Available x # of days in period 24 10 Room Revenue Single Rate x # Rooms Available x # of days in period 20 10 # 1372.5 1237.6 A-B [Double occupied Occupancy x Double (Single Rate x Rooms) + factor-1 Differential) May-Oct 183 183 X 43920 36600 7320 Occupancy %] 8 Points Last Year 1281 1146.6 40260 32940 7320 28182 13070 10 Double Differential Formula A Double Rate x # Rooms Available x # of days in period 24 10 B Single Rate x # Rooms Available x # of days in period 20 10 Room Revenue 3 Points # Nov-Apr A-B [Double occupied Occupancy x Double (Single Rate X Rooms) + factor -1 Differential) May-Oct 183 183 X 43920 36600 7320 Occupancy %] 40260 32940 7320 28182 22029.48 50211.48 1 Assumptions made to prepare Expenses Forecasts 2 Variable expenses are estimated based on projected volumns 3 4 5 Salaries, Wages and Employee Benefits 51 maid @ $11,000 71 grounds keeper (summer student) @ $4000 Owner's Salary is $12,000 annually 9 0 Employee Benefits @ 8% of Salary & Wages 1 2 Other Expenses 3 Room Expenses 4 Other room expenses are 6% of room sales at the Towne Motel 5 Telephone Expense 6 Estimated at 140% of telephone revenues Subtotal 7 Energy Cost 8 Energy cost were $3000 last year. Due to a slight 9 increase in occupancy and an anticipated increase of 0 8% the estimate for next year is $3400. 1 35% summer and 65% winter 2 Property Operation and Maintenance 3 If possible, you should cost any planned renovations; Assignment Assumptions Operating budget Cash Budget G May-Oct Nov - Apr A B F increase in occupancy and an anticipated increase of 8% the estimate for next year is $3400. 35% summer and 65% winter D Property Operation and Maintenance If possible, you should cost any planned renovations; in addition. A base amount should be included We have assumed that $1700 was spent in the first period and $1300 was spent in the second period Your marketing budget and Administrative and General Expenses are estimated Financial and Other Expenses Interest expenses are obtained from Mortgage Co. Towne Motel interest charges are $6750 for year 3 Local Insurance estimates premium $750/year Based on CCA and asset values depreciation is projected at $3000 5 Municipal Taxes 5 Estimate based on local municipal tax department $1500 annually The projected income tax that will be applied is 28% 8 Last years closing cash balance was $3000 9 0 1 2 650 700 H 5 Points 850 650 → Revenues Guest Rooms Telephone Other Income Total 1 2 Operating Expenses 3 Salaries & Wages Towne Motel Annual Operating budget Period Ending April 30 4 Employee Benefits 5 Direct Operating Expenses 6 Administration & General 7 Marketing 8 Property Operation & Maintenance 9 Energy Costs 0 Total 1 2 Income Before Fixed Charges 3 May - October Actual Budget November-April Actual Budget Assignment Assumptions Operating budget Cash Budget ) B Tables A Administration & General Marketing Property Operation & Maintenance Energy Costs Total Income Before Fixed Charges 1 X Financial and Other Expenses 5 Municipal Taxes 6 Insurance 7 Interest 8 Total 36 37 38 9 0 Income Before Depreciation 31 Depreciation 32 33 Income before Income Tax 34 Income Taxes 35 Net Income Point illustrations E48 'Operating budget'!110 + B Assignment Assumptions Operating budget C Cash Budget Add-ins D 44 Points F A Cash, Opening Balance Cash Receipts Revenues Proceeds from any Loans Cash contributions from Owner Total Cash Receipts Cash Disbursements Total Expenses Total Fixed Expenses Cash drawings by Owners Repayment of any debt Total Cash Disbursements Net Cash Flow Cash Closing Balance. Assignment B Towne Motel Cash Flow Budget May-October Budget Actual D November-April Budget Actual Assumptions Operating budget Cash Budget F Annual Budget Actual 30 Points H The Towne Motel has 10 rooms and it open year round. It has no food or beverage facilities. We'll assume you would like to achieve a net after-tax income of approximately $3000 for the year, which is a 10% return on equity of $30,000 The division of your budget into planning periods are best defined as May 1 - October 31 and November 1 - April 30 since the Towne Motel is located in a summer tourist area. The factors and trends expected to affect your business. The Towne Motel has been in business for 10 years and you have developed a solid relationship with your repeat gueats. You do not anticipate any major changes in demand by this market. However, a local motor-inn of comparable facilities has just gone out of business. As a result, you feel your annual occupancy should increase by 5%. The local economy is stable. However, you expect a general increase in prices of 8%. Some rooms will require small renovations $1700 will be spent in June and $1300 will be spent in December Your marketing budget is $650 for May-Oct. and $850 for winter season O Administrative and general expenses are estimated at $ 700 for May- Oct. and $650 for Nov - April 2 Estimate Telephone revenues at $1.50 per occupied room night and Other income at 1% of total reveunes. The owners withdrew $2500 semi annually as drawings from the businessand managed to repay $350 monthly in debt to the local bank Occupied Room Nights May - October November - April Double Occupancy factor May-October November - April Room Rates Single Double Room Revenues May - October November - April Projected 1345 1204 2.0 1.3 $20.00 $. 24.00 =E48 054 75% 68% Last Year 1281 1147 2.0 1.3 $18.00 $ 22.00 70% 63% Room Revenues May-October November - April Total Show your calculations PROJECTED # OF OCCUPIED ROOMS 10 x 183 x.75 10 x 182 x .68 May-Oct Nov-Apr B E48 054 Double Differential Formula A Double Rate x # Rooms Available x # of days in period 24 10 Room Revenue Single Rate x # Rooms Available x # of days in period 20 10 # 1372.5 1237.6 A-B [Double occupied Occupancy x Double (Single Rate x Rooms) + factor-1 Differential) May-Oct 183 183 X 43920 36600 7320 Occupancy %] 8 Points Last Year 1281 1146.6 40260 32940 7320 28182 13070 10 Double Differential Formula A Double Rate x # Rooms Available x # of days in period 24 10 B Single Rate x # Rooms Available x # of days in period 20 10 Room Revenue 3 Points # Nov-Apr A-B [Double occupied Occupancy x Double (Single Rate X Rooms) + factor -1 Differential) May-Oct 183 183 X 43920 36600 7320 Occupancy %] 40260 32940 7320 28182 22029.48 50211.48 1 Assumptions made to prepare Expenses Forecasts 2 Variable expenses are estimated based on projected volumns 3 4 5 Salaries, Wages and Employee Benefits 51 maid @ $11,000 71 grounds keeper (summer student) @ $4000 Owner's Salary is $12,000 annually 9 0 Employee Benefits @ 8% of Salary & Wages 1 2 Other Expenses 3 Room Expenses 4 Other room expenses are 6% of room sales at the Towne Motel 5 Telephone Expense 6 Estimated at 140% of telephone revenues Subtotal 7 Energy Cost 8 Energy cost were $3000 last year. Due to a slight 9 increase in occupancy and an anticipated increase of 0 8% the estimate for next year is $3400. 1 35% summer and 65% winter 2 Property Operation and Maintenance 3 If possible, you should cost any planned renovations; Assignment Assumptions Operating budget Cash Budget G May-Oct Nov - Apr A B F increase in occupancy and an anticipated increase of 8% the estimate for next year is $3400. 35% summer and 65% winter D Property Operation and Maintenance If possible, you should cost any planned renovations; in addition. A base amount should be included We have assumed that $1700 was spent in the first period and $1300 was spent in the second period Your marketing budget and Administrative and General Expenses are estimated Financial and Other Expenses Interest expenses are obtained from Mortgage Co. Towne Motel interest charges are $6750 for year 3 Local Insurance estimates premium $750/year Based on CCA and asset values depreciation is projected at $3000 5 Municipal Taxes 5 Estimate based on local municipal tax department $1500 annually The projected income tax that will be applied is 28% 8 Last years closing cash balance was $3000 9 0 1 2 650 700 H 5 Points 850 650 → Revenues Guest Rooms Telephone Other Income Total 1 2 Operating Expenses 3 Salaries & Wages Towne Motel Annual Operating budget Period Ending April 30 4 Employee Benefits 5 Direct Operating Expenses 6 Administration & General 7 Marketing 8 Property Operation & Maintenance 9 Energy Costs 0 Total 1 2 Income Before Fixed Charges 3 May - October Actual Budget November-April Actual Budget Assignment Assumptions Operating budget Cash Budget ) B Tables A Administration & General Marketing Property Operation & Maintenance Energy Costs Total Income Before Fixed Charges 1 X Financial and Other Expenses 5 Municipal Taxes 6 Insurance 7 Interest 8 Total 36 37 38 9 0 Income Before Depreciation 31 Depreciation 32 33 Income before Income Tax 34 Income Taxes 35 Net Income Point illustrations E48 'Operating budget'!110 + B Assignment Assumptions Operating budget C Cash Budget Add-ins D 44 Points F A Cash, Opening Balance Cash Receipts Revenues Proceeds from any Loans Cash contributions from Owner Total Cash Receipts Cash Disbursements Total Expenses Total Fixed Expenses Cash drawings by Owners Repayment of any debt Total Cash Disbursements Net Cash Flow Cash Closing Balance. Assignment B Towne Motel Cash Flow Budget May-October Budget Actual D November-April Budget Actual Assumptions Operating budget Cash Budget F Annual Budget Actual 30 Points H The Towne Motel has 10 rooms and it open year round. It has no food or beverage facilities. We'll assume you would like to achieve a net after-tax income of approximately $3000 for the year, which is a 10% return on equity of $30,000 The division of your budget into planning periods are best defined as May 1 - October 31 and November 1 - April 30 since the Towne Motel is located in a summer tourist area. The factors and trends expected to affect your business. The Towne Motel has been in business for 10 years and you have developed a solid relationship with your repeat gueats. You do not anticipate any major changes in demand by this market. However, a local motor-inn of comparable facilities has just gone out of business. As a result, you feel your annual occupancy should increase by 5%. The local economy is stable. However, you expect a general increase in prices of 8%. Some rooms will require small renovations $1700 will be spent in June and $1300 will be spent in December Your marketing budget is $650 for May-Oct. and $850 for winter season O Administrative and general expenses are estimated at $ 700 for May- Oct. and $650 for Nov - April 2 Estimate Telephone revenues at $1.50 per occupied room night and Other income at 1% of total reveunes. The owners withdrew $2500 semi annually as drawings from the businessand managed to repay $350 monthly in debt to the local bank Occupied Room Nights May - October November - April Double Occupancy factor May-October November - April Room Rates Single Double Room Revenues May - October November - April Projected 1345 1204 2.0 1.3 $20.00 $. 24.00 =E48 054 75% 68% Last Year 1281 1147 2.0 1.3 $18.00 $ 22.00 70% 63% Room Revenues May-October November - April Total Show your calculations PROJECTED # OF OCCUPIED ROOMS 10 x 183 x.75 10 x 182 x .68 May-Oct Nov-Apr B E48 054 Double Differential Formula A Double Rate x # Rooms Available x # of days in period 24 10 Room Revenue Single Rate x # Rooms Available x # of days in period 20 10 # 1372.5 1237.6 A-B [Double occupied Occupancy x Double (Single Rate x Rooms) + factor-1 Differential) May-Oct 183 183 X 43920 36600 7320 Occupancy %] 8 Points Last Year 1281 1146.6 40260 32940 7320 28182 13070 10 Double Differential Formula A Double Rate x # Rooms Available x # of days in period 24 10 B Single Rate x # Rooms Available x # of days in period 20 10 Room Revenue 3 Points # Nov-Apr A-B [Double occupied Occupancy x Double (Single Rate X Rooms) + factor -1 Differential) May-Oct 183 183 X 43920 36600 7320 Occupancy %] 40260 32940 7320 28182 22029.48 50211.48 1 Assumptions made to prepare Expenses Forecasts 2 Variable expenses are estimated based on projected volumns 3 4 5 Salaries, Wages and Employee Benefits 51 maid @ $11,000 71 grounds keeper (summer student) @ $4000 Owner's Salary is $12,000 annually 9 0 Employee Benefits @ 8% of Salary & Wages 1 2 Other Expenses 3 Room Expenses 4 Other room expenses are 6% of room sales at the Towne Motel 5 Telephone Expense 6 Estimated at 140% of telephone revenues Subtotal 7 Energy Cost 8 Energy cost were $3000 last year. Due to a slight 9 increase in occupancy and an anticipated increase of 0 8% the estimate for next year is $3400. 1 35% summer and 65% winter 2 Property Operation and Maintenance 3 If possible, you should cost any planned renovations; Assignment Assumptions Operating budget Cash Budget G May-Oct Nov - Apr A B F increase in occupancy and an anticipated increase of 8% the estimate for next year is $3400. 35% summer and 65% winter D Property Operation and Maintenance If possible, you should cost any planned renovations; in addition. A base amount should be included We have assumed that $1700 was spent in the first period and $1300 was spent in the second period Your marketing budget and Administrative and General Expenses are estimated Financial and Other Expenses Interest expenses are obtained from Mortgage Co. Towne Motel interest charges are $6750 for year 3 Local Insurance estimates premium $750/year Based on CCA and asset values depreciation is projected at $3000 5 Municipal Taxes 5 Estimate based on local municipal tax department $1500 annually The projected income tax that will be applied is 28% 8 Last years closing cash balance was $3000 9 0 1 2 650 700 H 5 Points 850 650 → Revenues Guest Rooms Telephone Other Income Total 1 2 Operating Expenses 3 Salaries & Wages Towne Motel Annual Operating budget Period Ending April 30 4 Employee Benefits 5 Direct Operating Expenses 6 Administration & General 7 Marketing 8 Property Operation & Maintenance 9 Energy Costs 0 Total 1 2 Income Before Fixed Charges 3 May - October Actual Budget November-April Actual Budget Assignment Assumptions Operating budget Cash Budget ) B Tables A Administration & General Marketing Property Operation & Maintenance Energy Costs Total Income Before Fixed Charges 1 X Financial and Other Expenses 5 Municipal Taxes 6 Insurance 7 Interest 8 Total 36 37 38 9 0 Income Before Depreciation 31 Depreciation 32 33 Income before Income Tax 34 Income Taxes 35 Net Income Point illustrations E48 'Operating budget'!110 + B Assignment Assumptions Operating budget C Cash Budget Add-ins D 44 Points F A Cash, Opening Balance Cash Receipts Revenues Proceeds from any Loans Cash contributions from Owner Total Cash Receipts Cash Disbursements Total Expenses Total Fixed Expenses Cash drawings by Owners Repayment of any debt Total Cash Disbursements Net Cash Flow Cash Closing Balance. Assignment B Towne Motel Cash Flow Budget May-October Budget Actual D November-April Budget Actual Assumptions Operating budget Cash Budget F Annual Budget Actual 30 Points H The Towne Motel has 10 rooms and it open year round. It has no food or beverage facilities. We'll assume you would like to achieve a net after-tax income of approximately $3000 for the year, which is a 10% return on equity of $30,000 The division of your budget into planning periods are best defined as May 1 - October 31 and November 1 - April 30 since the Towne Motel is located in a summer tourist area. The factors and trends expected to affect your business. The Towne Motel has been in business for 10 years and you have developed a solid relationship with your repeat gueats. You do not anticipate any major changes in demand by this market. However, a local motor-inn of comparable facilities has just gone out of business. As a result, you feel your annual occupancy should increase by 5%. The local economy is stable. However, you expect a general increase in prices of 8%. Some rooms will require small renovations $1700 will be spent in June and $1300 will be spent in December Your marketing budget is $650 for May-Oct. and $850 for winter season O Administrative and general expenses are estimated at $ 700 for May- Oct. and $650 for Nov - April 2 Estimate Telephone revenues at $1.50 per occupied room night and Other income at 1% of total reveunes. The owners withdrew $2500 semi annually as drawings from the businessand managed to repay $350 monthly in debt to the local bank Occupied Room Nights May - October November - April Double Occupancy factor May-October November - April Room Rates Single Double Room Revenues May - October November - April Projected 1345 1204 2.0 1.3 $20.00 $. 24.00 =E48 054 75% 68% Last Year 1281 1147 2.0 1.3 $18.00 $ 22.00 70% 63% Room Revenues May-October November - April Total Show your calculations PROJECTED # OF OCCUPIED ROOMS 10 x 183 x.75 10 x 182 x .68 May-Oct Nov-Apr B E48 054 Double Differential Formula A Double Rate x # Rooms Available x # of days in period 24 10 Room Revenue Single Rate x # Rooms Available x # of days in period 20 10 # 1372.5 1237.6 A-B [Double occupied Occupancy x Double (Single Rate x Rooms) + factor-1 Differential) May-Oct 183 183 X 43920 36600 7320 Occupancy %] 8 Points Last Year 1281 1146.6 40260 32940 7320 28182 13070 10 Double Differential Formula A Double Rate x # Rooms Available x # of days in period 24 10 B Single Rate x # Rooms Available x # of days in period 20 10 Room Revenue 3 Points # Nov-Apr A-B [Double occupied Occupancy x Double (Single Rate X Rooms) + factor -1 Differential) May-Oct 183 183 X 43920 36600 7320 Occupancy %] 40260 32940 7320 28182 22029.48 50211.48 1 Assumptions made to prepare Expenses Forecasts 2 Variable expenses are estimated based on projected volumns 3 4 5 Salaries, Wages and Employee Benefits 51 maid @ $11,000 71 grounds keeper (summer student) @ $4000 Owner's Salary is $12,000 annually 9 0 Employee Benefits @ 8% of Salary & Wages 1 2 Other Expenses 3 Room Expenses 4 Other room expenses are 6% of room sales at the Towne Motel 5 Telephone Expense 6 Estimated at 140% of telephone revenues Subtotal 7 Energy Cost 8 Energy cost were $3000 last year. Due to a slight 9 increase in occupancy and an anticipated increase of 0 8% the estimate for next year is $3400. 1 35% summer and 65% winter 2 Property Operation and Maintenance 3 If possible, you should cost any planned renovations; Assignment Assumptions Operating budget Cash Budget G May-Oct Nov - Apr A B F increase in occupancy and an anticipated increase of 8% the estimate for next year is $3400. 35% summer and 65% winter D Property Operation and Maintenance If possible, you should cost any planned renovations; in addition. A base amount should be included We have assumed that $1700 was spent in the first period and $1300 was spent in the second period Your marketing budget and Administrative and General Expenses are estimated Financial and Other Expenses Interest expenses are obtained from Mortgage Co. Towne Motel interest charges are $6750 for year 3 Local Insurance estimates premium $750/year Based on CCA and asset values depreciation is projected at $3000 5 Municipal Taxes 5 Estimate based on local municipal tax department $1500 annually The projected income tax that will be applied is 28% 8 Last years closing cash balance was $3000 9 0 1 2 650 700 H 5 Points 850 650 → Revenues Guest Rooms Telephone Other Income Total 1 2 Operating Expenses 3 Salaries & Wages Towne Motel Annual Operating budget Period Ending April 30 4 Employee Benefits 5 Direct Operating Expenses 6 Administration & General 7 Marketing 8 Property Operation & Maintenance 9 Energy Costs 0 Total 1 2 Income Before Fixed Charges 3 May - October Actual Budget November-April Actual Budget Assignment Assumptions Operating budget Cash Budget ) B Tables A Administration & General Marketing Property Operation & Maintenance Energy Costs Total Income Before Fixed Charges 1 X Financial and Other Expenses 5 Municipal Taxes 6 Insurance 7 Interest 8 Total 36 37 38 9 0 Income Before Depreciation 31 Depreciation 32 33 Income before Income Tax 34 Income Taxes 35 Net Income Point illustrations E48 'Operating budget'!110 + B Assignment Assumptions Operating budget C Cash Budget Add-ins D 44 Points F A Cash, Opening Balance Cash Receipts Revenues Proceeds from any Loans Cash contributions from Owner Total Cash Receipts Cash Disbursements Total Expenses Total Fixed Expenses Cash drawings by Owners Repayment of any debt Total Cash Disbursements Net Cash Flow Cash Closing Balance. Assignment B Towne Motel Cash Flow Budget May-October Budget Actual D November-April Budget Actual Assumptions Operating budget Cash Budget F Annual Budget Actual 30 Points H The Towne Motel has 10 rooms and it open year round. It has no food or beverage facilities. We'll assume you would like to achieve a net after-tax income of approximately $3000 for the year, which is a 10% return on equity of $30,000 The division of your budget into planning periods are best defined as May 1 - October 31 and November 1 - April 30 since the Towne Motel is located in a summer tourist area. The factors and trends expected to affect your business. The Towne Motel has been in business for 10 years and you have developed a solid relationship with your repeat gueats. You do not anticipate any major changes in demand by this market. However, a local motor-inn of comparable facilities has just gone out of business. As a result, you feel your annual occupancy should increase by 5%. The local economy is stable. However, you expect a general increase in prices of 8%. Some rooms will require small renovations $1700 will be spent in June and $1300 will be spent in December Your marketing budget is $650 for May-Oct. and $850 for winter season O Administrative and general expenses are estimated at $ 700 for May- Oct. and $650 for Nov - April 2 Estimate Telephone revenues at $1.50 per occupied room night and Other income at 1% of total reveunes. The owners withdrew $2500 semi annually as drawings from the businessand managed to repay $350 monthly in debt to the local bank Occupied Room Nights May - October November - April Double Occupancy factor May-October November - April Room Rates Single Double Room Revenues May - October November - April Projected 1345 1204 2.0 1.3 $20.00 $. 24.00 =E48 054 75% 68% Last Year 1281 1147 2.0 1.3 $18.00 $ 22.00 70% 63% Room Revenues May-October November - April Total Show your calculations PROJECTED # OF OCCUPIED ROOMS 10 x 183 x.75 10 x 182 x .68 May-Oct Nov-Apr B E48 054 Double Differential Formula A Double Rate x # Rooms Available x # of days in period 24 10 Room Revenue Single Rate x # Rooms Available x # of days in period 20 10 # 1372.5 1237.6 A-B [Double occupied Occupancy x Double (Single Rate x Rooms) + factor-1 Differential) May-Oct 183 183 X 43920 36600 7320 Occupancy %] 8 Points Last Year 1281 1146.6 40260 32940 7320 28182 13070 10 Double Differential Formula A Double Rate x # Rooms Available x # of days in period 24 10 B Single Rate x # Rooms Available x # of days in period 20 10 Room Revenue 3 Points # Nov-Apr A-B [Double occupied Occupancy x Double (Single Rate X Rooms) + factor -1 Differential) May-Oct 183 183 X 43920 36600 7320 Occupancy %] 40260 32940 7320 28182 22029.48 50211.48 1 Assumptions made to prepare Expenses Forecasts 2 Variable expenses are estimated based on projected volumns 3 4 5 Salaries, Wages and Employee Benefits 51 maid @ $11,000 71 grounds keeper (summer student) @ $4000 Owner's Salary is $12,000 annually 9 0 Employee Benefits @ 8% of Salary & Wages 1 2 Other Expenses 3 Room Expenses 4 Other room expenses are 6% of room sales at the Towne Motel 5 Telephone Expense 6 Estimated at 140% of telephone revenues Subtotal 7 Energy Cost 8 Energy cost were $3000 last year. Due to a slight 9 increase in occupancy and an anticipated increase of 0 8% the estimate for next year is $3400. 1 35% summer and 65% winter 2 Property Operation and Maintenance 3 If possible, you should cost any planned renovations; Assignment Assumptions Operating budget Cash Budget G May-Oct Nov - Apr A B F increase in occupancy and an anticipated increase of 8% the estimate for next year is $3400. 35% summer and 65% winter D Property Operation and Maintenance If possible, you should cost any planned renovations; in addition. A base amount should be included We have assumed that $1700 was spent in the first period and $1300 was spent in the second period Your marketing budget and Administrative and General Expenses are estimated Financial and Other Expenses Interest expenses are obtained from Mortgage Co. Towne Motel interest charges are $6750 for year 3 Local Insurance estimates premium $750/year Based on CCA and asset values depreciation is projected at $3000 5 Municipal Taxes 5 Estimate based on local municipal tax department $1500 annually The projected income tax that will be applied is 28% 8 Last years closing cash balance was $3000 9 0 1 2 650 700 H 5 Points 850 650 → Revenues Guest Rooms Telephone Other Income Total 1 2 Operating Expenses 3 Salaries & Wages Towne Motel Annual Operating budget Period Ending April 30 4 Employee Benefits 5 Direct Operating Expenses 6 Administration & General 7 Marketing 8 Property Operation & Maintenance 9 Energy Costs 0 Total 1 2 Income Before Fixed Charges 3 May - October Actual Budget November-April Actual Budget Assignment Assumptions Operating budget Cash Budget ) B Tables A Administration & General Marketing Property Operation & Maintenance Energy Costs Total Income Before Fixed Charges 1 X Financial and Other Expenses 5 Municipal Taxes 6 Insurance 7 Interest 8 Total 36 37 38 9 0 Income Before Depreciation 31 Depreciation 32 33 Income before Income Tax 34 Income Taxes 35 Net Income Point illustrations E48 'Operating budget'!110 + B Assignment Assumptions Operating budget C Cash Budget Add-ins D 44 Points F A Cash, Opening Balance Cash Receipts Revenues Proceeds from any Loans Cash contributions from Owner Total Cash Receipts Cash Disbursements Total Expenses Total Fixed Expenses Cash drawings by Owners Repayment of any debt Total Cash Disbursements Net Cash Flow Cash Closing Balance. Assignment B Towne Motel Cash Flow Budget May-October Budget Actual D November-April Budget Actual Assumptions Operating budget Cash Budget F Annual Budget Actual 30 Points H The Towne Motel has 10 rooms and it open year round. It has no food or beverage facilities. We'll assume you would like to achieve a net after-tax income of approximately $3000 for the year, which is a 10% return on equity of $30,000 The division of your budget into planning periods are best defined as May 1 - October 31 and November 1 - April 30 since the Towne Motel is located in a summer tourist area. The factors and trends expected to affect your business. The Towne Motel has been in business for 10 years and you have developed a solid relationship with your repeat gueats. You do not anticipate any major changes in demand by this market. However, a local motor-inn of comparable facilities has just gone out of business. As a result, you feel your annual occupancy should increase by 5%. The local economy is stable. However, you expect a general increase in prices of 8%. Some rooms will require small renovations $1700 will be spent in June and $1300 will be spent in December Your marketing budget is $650 for May-Oct. and $850 for winter season O Administrative and general expenses are estimated at $ 700 for May- Oct. and $650 for Nov - April 2 Estimate Telephone revenues at $1.50 per occupied room night and Other income at 1% of total reveunes. The owners withdrew $2500 semi annually as drawings from the businessand managed to repay $350 monthly in debt to the local bank Occupied Room Nights May - October November - April Double Occupancy factor May-October November - April Room Rates Single Double Room Revenues May - October November - April Projected 1345 1204 2.0 1.3 $20.00 $. 24.00 =E48 054 75% 68% Last Year 1281 1147 2.0 1.3 $18.00 $ 22.00 70% 63% Room Revenues May-October November - April Total Show your calculations PROJECTED # OF OCCUPIED ROOMS 10 x 183 x.75 10 x 182 x .68 May-Oct Nov-Apr B E48 054 Double Differential Formula A Double Rate x # Rooms Available x # of days in period 24 10 Room Revenue Single Rate x # Rooms Available x # of days in period 20 10 # 1372.5 1237.6 A-B [Double occupied Occupancy x Double (Single Rate x Rooms) + factor-1 Differential) May-Oct 183 183 X 43920 36600 7320 Occupancy %] 8 Points Last Year 1281 1146.6 40260 32940 7320 28182 13070 10 Double Differential Formula A Double Rate x # Rooms Available x # of days in period 24 10 B Single Rate x # Rooms Available x # of days in period 20 10 Room Revenue 3 Points # Nov-Apr A-B [Double occupied Occupancy x Double (Single Rate X Rooms) + factor -1 Differential) May-Oct 183 183 X 43920 36600 7320 Occupancy %] 40260 32940 7320 28182 22029.48 50211.48 1 Assumptions made to prepare Expenses Forecasts 2 Variable expenses are estimated based on projected volumns 3 4 5 Salaries, Wages and Employee Benefits 51 maid @ $11,000 71 grounds keeper (summer student) @ $4000 Owner's Salary is $12,000 annually 9 0 Employee Benefits @ 8% of Salary & Wages 1 2 Other Expenses 3 Room Expenses 4 Other room expenses are 6% of room sales at the Towne Motel 5 Telephone Expense 6 Estimated at 140% of telephone revenues Subtotal 7 Energy Cost 8 Energy cost were $3000 last year. Due to a slight 9 increase in occupancy and an anticipated increase of 0 8% the estimate for next year is $3400. 1 35% summer and 65% winter 2 Property Operation and Maintenance 3 If possible, you should cost any planned renovations; Assignment Assumptions Operating budget Cash Budget G May-Oct Nov - Apr A B F increase in occupancy and an anticipated increase of 8% the estimate for next year is $3400. 35% summer and 65% winter D Property Operation and Maintenance If possible, you should cost any planned renovations; in addition. A base amount should be included We have assumed that $1700 was spent in the first period and $1300 was spent in the second period Your marketing budget and Administrative and General Expenses are estimated Financial and Other Expenses Interest expenses are obtained from Mortgage Co. Towne Motel interest charges are $6750 for year 3 Local Insurance estimates premium $750/year Based on CCA and asset values depreciation is projected at $3000 5 Municipal Taxes 5 Estimate based on local municipal tax department $1500 annually The projected income tax that will be applied is 28% 8 Last years closing cash balance was $3000 9 0 1 2 650 700 H 5 Points 850 650 → Revenues Guest Rooms Telephone Other Income Total 1 2 Operating Expenses 3 Salaries & Wages Towne Motel Annual Operating budget Period Ending April 30 4 Employee Benefits 5 Direct Operating Expenses 6 Administration & General 7 Marketing 8 Property Operation & Maintenance 9 Energy Costs 0 Total 1 2 Income Before Fixed Charges 3 May - October Actual Budget November-April Actual Budget Assignment Assumptions Operating budget Cash Budget ) B Tables A Administration & General Marketing Property Operation & Maintenance Energy Costs Total Income Before Fixed Charges 1 X Financial and Other Expenses 5 Municipal Taxes 6 Insurance 7 Interest 8 Total 36 37 38 9 0 Income Before Depreciation 31 Depreciation 32 33 Income before Income Tax 34 Income Taxes 35 Net Income Point illustrations E48 'Operating budget'!110 + B Assignment Assumptions Operating budget C Cash Budget Add-ins D 44 Points F A Cash, Opening Balance Cash Receipts Revenues Proceeds from any Loans Cash contributions from Owner Total Cash Receipts Cash Disbursements Total Expenses Total Fixed Expenses Cash drawings by Owners Repayment of any debt Total Cash Disbursements Net Cash Flow Cash Closing Balance. Assignment B Towne Motel Cash Flow Budget May-October Budget Actual D November-April Budget Actual Assumptions Operating budget Cash Budget F Annual Budget Actual 30 Points H
Expert Answer:
Related Book For
Accounting Principles
ISBN: 978-0470534793
10th Edition
Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso
Posted Date:
Students also viewed these accounting questions
-
Management Accounting - Group Project You would like to start a trading business in 2021 and you plan to invest $200,000 as capital and to borrow from bank for any additional amount that is necessary...
-
Please describe one accounting research question you would like to explore using archival empirical methodology. This research question should examine the association between two variables (i.e.,...
-
You have two possessions you would like to insure against theft or damage: your new bicycle, which cost you $800, and a painting you inherited, which has been appraised at $55,000. The painting is...
-
Eric Ishton, a manager of the Plate Division for the Stone Ware Manufacturing company, has the opportunity to expand the division by investing in additional machinery costing $430,000. He would...
-
Complete the frequency table that corresponds to the frequency table in the exercise indicated by adding the relative frequency and cumulative relative frequency columns, accurate to 3 decimals....
-
Court decisions that later courts tend to follow. a. administrative law b. appellate court c. civil law d. common law e. criminal law f. defendants g. express powers h. implied powers i. original...
-
A contract is created to refurbish a luxury yacht: new color schemes, new furniture, new wall and floor coverings, new light fixtures, and window treatmentsthe whole works. Of course, it is not just...
-
(Amortization of Accumulated OCI Balances) Keeton Company sponsors a defined-benefit pension plan for its 600 employees. The company's actuary provided the following information about the plan. The...
-
In a random walk suppose that at t = (n - 1)At the particle is located at x = max. The assumption is that at t = nAt the particle will have moved to x = (m+1)Ax with probability 3/4 or to x = (m-3)Ax...
-
1. Given the facts of the case, what communications do you believe Forrester & Loomis should have made with the audit committee with regard to the transactions with the vendor to comply with PCAOB AS...
-
Answer the following questions: 1. How does Toyota create utility for consumers? 2. In what ways does Toyota practice relationship marketing? 3. How would you describe the role of critical and...
-
Make program. Draw the curve of y=x+2x+3 and xe[-10, 10].
-
Executive Summary Assignment: "Merger Integration at Bank of America: The TrustWeb Project" Assume the role of Mike Morris preparing for his Monday meeting. Determine what steps Morris should take...
-
A stream of aqueous methanol having 45 mol % CHOH is to be separated into a top product having 96 mol% methanol and a bottom liquid with 4 mol % methanol. The feed at its bubble point and the...
-
Consider the following three vectors in R: V = (a) Show that = (V, V2, V3) is a basis for R. Consider the following four vectors in R4: = 1 --0--0---0--(-)) = 1 -(). -(-9). -0). 0 = V3 = 3 1 1 (b)...
-
The following data is provided for Garcon Company and Pepper Company. Garcon Company Pepper Company Beginning finished goods inventory $ 14,400 $ 19,150 Beginning work in process inventory 14,500...
-
Full employment, keeping inflation under control, and economic growth are among the major macroeconomic goals of all societies. Why is economic growth a major macroeco- nomic goal? What is potential...
-
A heat engine has a heat input of 3 Ã 104 Btu/h and a thermal efficiency of 40 percent. Calculate the power it will produce, in hp. Source 3 x 10 Btu/h 40% HE Sink
-
Forte Company begins operations on April 1. Information from job cost sheets shows the following. Job 12 was completed in April. Job 10 was completed in May. Jobs 11 and 13 were completed in June....
-
Carla Quentin started her own consulting firm, Quentin Consulting, on May 1, 2012. The following transactions occurred during the month of May. May 1 Carla invested $7,000 cash in the business. 2...
-
The following account balances relate to the stockholders equity accounts of Chipo Corp. at year-end. A small stock dividend was declared and issued in 2012. The market value of the shares was...
-
Demonstrate that both the Berry phase \(\gamma_{n}\) and the Berry curvature \(\boldsymbol{\Omega}_{n}(\boldsymbol{R})\) are invariant under a local gauge transformation.
-
Show that under a local gauge transformation (14.5) the vector potential A and the form of the wavefunction (28.7) are changed, but no observable is affected. Data from Eq. 28.7 Data from Eq. 14.5...
-
Evaluate the formula for the Gauss-Bonnet theorem in Box 28.3 for a 2-sphere and show that this leads to the usual relation for the area of a sphere. The local curvature for a 2-surface is the...
Study smarter with the SolutionInn App