i have a template for assignment if needed.

1. Doris Halloran has been asked to invest in her friend Roger's new business venture. The new business will consist of three food trucks operating in the downtown business district of a large metropolitan area. Roger is asking Doris to invest $80,000 in the business and assures her that it will make enough money to return $20,000 in profits per year to her. Calculate the estimated return on investment (to one decimal place) that Doris would achieve if Roger is correct. Also, calculate the returns Doris would achieve if the restaurant is only profitable enough to return to her $15,000, $10,000, or $5000 and then answer the questions that follow. Estimated Return on Investment (ROI) (%) Investment Amount ($) 80,000 80,000 80,000 80,000 Estimated Profits to be returned ($) 20,000 15,000 10,000 5,000 a. Assume that Doris has $80,000 available to invest. What are some factors she should consider before deciding to help Roger in his new business venture? b. What specific information do you think Doris would want Roger to provide her prior to making her invest- ment decision? 2. Nicole Englezakis manages a South African restaurant in a large southern city. The owner wants to know how well Nicole did this year at generating sales, controlling expenses, and providing a profit. Complete Nicole's P&L below using vertical analysis. a. When comparing this year to last year, was Nicole's marketing expense in dollars higher or lower? b. Was Nicole's marketing expense percentage higher or lower this year? c. Do you think that her marketing expense this year positively or negatively contributed to her revenues? Why? d. When comparing this year to last year, was Nicole's labor expense in dollars higher or lower? e. Was Nicole's labor expense percentage higher or lower this year? f. Do you think that her salaries and wages expense this year positively or negatively contributed to her net income? Why? g. The owner promised Nicole that he would give her a raise if she increased the operation's net income by at least 2% of total sales. Should Nicole receive a raise? Why or why not? Nicole's P&L Last Year ($) This Year ($) 3,706,881 647,555 3,746,245 1,255,358 SALES Food Beverage Total Sales COST OF SALES Food Beverage Total Cost of Sales LABOR Management Staff Employee Benefits Total Labor 1,282,656 145,607 1,611,630 162,231 348,615 882,295 190,394 392,626 864,153 196790 PRIME COST Chapter 3 The Income Statement This Year ($) % Last Year ($) OTHER CONTROLLABLE EXPENSES Direct Operating Expenses Music and Entertainment Marketing Utilities Administrative and General Repairs and Maintenance Total Other Controllable Expenses 234,670 4,427 84,126 141,688 128,403 66,416 232,571 13,418 111,813 156,538 125,230 62,616 CONTROLLABLE INCOME NON-CONTROLLABLE EXPENSES Occupancy Costs Depreciation Total Non-Controllable Expenses 230,400 79,699 310,099 211,200 98,397 309,597 RESTAURANT OPERATING INCOME Interest Expense 166,560 149,405 INCOME BEFORE INCOME TAXES Income Taxes 147,192 245,194 NET INCOME NET INCOME 3. Tony Marshall is the general manager of the 110-room Best Comfort hotel. Tony is compiling information to be used to develop the rooms revenue portion of his June statement of income. Tony knows that his total rooms revenue for the month was $265.650, but he would also like to create a supporting schedule detailing exactly how the rooms revenue was generated Tony's front office manager classifies rooms sales as transient, group, or contract. Complete the rooms revenue detail report presented below. Then, answer the questions that follow: Revenue % Best Comfort Hotel Rooms Revenue Detail: June Revenue ($) 138,138 Transient Rooms Revenue Group Rooms Revenue Contract Rooms Revenue Total Rooms Revenue 47,817 265,650 100% a. Which type of room sales contributed the largest dollar amount to Tony's June rooms revenue? b. Which type of room sales contributed the smallest percentage amount to Tony's June rooms revenue? 4. Terry Ray manages a large hotel in an urban Midwestern city. He wants to use vertical analysis and a slightly modified version of the USALI income statement (P&L) for his property to assess its financial performance last year. Complete the spreadsheet to help him evaluate his effectiveness as a manager. a. The owner gave Terry a goal of 65% for total operated department income. Did Terry perform better or worse than this goal? By how much? b. The owner also gave Terry a goal of 22% total undistributed operating expenses. Did Terry perform better or worse than this goal? By how much? c. The owner gave Terry a goal of 20% net income for the year. Did Terry perform better or worse than this goal? By how much? d. If you answered that Terry did not meet his goal in Question c, what could he do to get his P&L in line with the owner's goals