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...
-
Explain how the housing bubble at the beginning of the 21st century led to the Taylor rule target exceeding the actual federal funds rate. Could increasing the federal funds rate during this time...
-
What types of control would there be in a revenues credit system?
-
A crossover trial is a type of experiment used to compare two drugs. Subjects take one drug for a period of time, then switch to the other. The responses of the subjects are then compared using...
-
The weighted average cost of capital for a firm (assuming all three Modigliani and Miller assumptions apply) is 15 percent. What is the current cost of equity capital for the firm if its cost of debt...
-
1. Mitsubishi is a Japanese automobile manufacturer. Their business model attempts to minimise stocking up of raw materials in warehouses due to limited space availability. They also maintain minimum...
-
Poplar Outdoor Corporation owns 60 percent of the voting stock of Sugg Australia. Date-of-acquisition information is as follows: Acquisition cost: $59.25 million Fair value of the noncontrolling...
-
What is the silo effect? Why does it exist? What problems does it create? How can an organization reduce or eliminate the silo effect?
-
What does it mean when a bond exhibits negative convexity?
-
a. What does the duration of a bond measure? b. What does a bonds convexity measure? c. Is convexity a superior measure to duration?
-
What is meant by a shifting interest mechanism?
-
Explain how scenario analysis works?
-
Duration is only an accurate measure for very small changes in yield and assumes the yield shifts in parallel. Critically evaluate this statement.
-
Business Law - President Clinton Impeachment Case Taskmake Opening Statement for Defense Side - Defend for President Clinton Should also include the witness and evidence and what they would be prove...
-
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...
-
What is reaction coordinate? What is its significance in chemical reaction?
-
Show that for steady state flow process, \(\Delta H=Q-W_{S}\).
-
An ideal gas \(\left(C_{P}=5, C_{V}=3 ight)\) is changed from \(1 \mathrm{~atm}\) and \(22.4 \mathrm{~m}^{3}\) to \(10 \mathrm{~atm}\) and 2.24 \(\mathrm{m}^{3}\) by the reversible process of heating...
Study smarter with the SolutionInn App