Week 6 Assignment Final Project

Order 100% Plagiarism Free Paper Now

The final project is an INDIVIDUAL ASSESSMENT that will measure your understanding of the material that has been taught during the course. You need to submit your answers for this project using Excel.
Part A
From the Disney financial records provided below, construct the company’s balance sheet:
Machine and Equipment $450,000.
Inventories are $253,125.
Cash in the coffer (cash box) $26,000 and cash in the bank $100,000.
Account receivable in the amount of $270,000.
Employees need to be paid next week in the amount of $40,000, and an outstanding food bill is due next week in the amount of $57,200.
Short-term borrowing $60,300.
Due to the outstanding loan, accumulated interests are $68,400.
Net income leftover from last year that will be re-invested in the company in the amount of $288,225. [This is an accumulated leftover income as well.]
A small outstanding business administration loan in the amount of $135,000.
The company has shareholders with a capital amount of $450,000.

Week 6 Assignment Final Project

Order 100% Plagiarism Free Paper Now

Part B
From the Disney financial records provided below, construct the company’s income statement:
Proceeds from sales are $3,210,000.
Cost of food sold $802,500.
Operating expenses are $1,050,000.
Depreciation of the equipment is $75,000.
Interest expenses that are already paid on the loans are $26,250.
The tax bracket for the restaurant is 35%.
Construct a common size income statement by showing each line item of the income statement computed as a percentage of sales.
Part C
Disney purchased a new roller coaster for $250,000 at the beginning of the year. During the year, the roller coaster’s net proceeds were $50,000, and then it was sold for $190,000. Use this information to complete the following tasks:
Compute the ROI.
Should Disney invest in similar equipment in the future? Why?
Part D
You have been assigned to conduct a budget for the next month’s sales for the Twilight Zone Tower of Terror at Disney World, Florida. Management believes that the number of seats is likely to increase by 10% due to the high tourism season for the following 3 weeks. Below you have been provided with the first week’s actual sales. Conduct a short-term budget for the next 3 weeks’ sales (Round-up the number of occupied seats to the nearest seat/person).
Short-Term Budget Week 1 Week 2 Week 3 Week 4
Number of occupied seats 65
Cost per seat $15
Total $975

Week 6 Assignment Final Project

Order 100% Plagiarism Free Paper Now

Part E
A small Disney World Hotel Resort is trying to assess when their hotel becomes profitable. Provided are the cost-analysis for the resort:
Total fixed cost per month for the hotel (electricity, phone bill, room service) is $7,000.
Total variable cost per month for each room (guest supplies, breakfast F&B, etc.) is $10.
Rate sale per room is $150.
How many rooms need to be occupied to make the hotel generate a positive cash flow (i.e., be profitable)?
If the hotel has 40 occupied rooms for the month of July, would it be profitable? If not, what do you recommend to management?
Assignment Requirements:
Due by 11:59 p.m. Monday CT.
Submit all parts of the final project as an Excel sheet(s) in the Assignment 6.1 Final Project link above.
Submit Assignment:
Complete the assignment by clicking on the title above. Attach your saved Excel worksheet(s) and submit.

Week 6 Assignment Final Project

Order 100% Plagiarism Free Paper Now