1 2 Fast Clipboard F17 DITECTIONS. BIU- Font B X C A. fx =C17+D17-E17 E F Merge & Center - 4 $ - % 9 4.0.00 Conditional Format as .00 9.0 Alignment Number Cell Formatting - Table - Table Styles - Styles Insert Delete Fe Cells H Mario Armando Perez is the kitchen manager at the Asahi Sushi House. Mario's restaurant offers five popular types of sushi roll. Mario keeps 4 careful records of the number of each roll type sold, from which he computes each item's popularity index. For March 1, Mario estimates 150 5 guests will be served. 6 8 9 10 11 04 At the end of the day, Mario also records his actual number sold in order to calculate his carryover amount for the next day. 7 Based on his experience, and to ensure he does not run out of any item, Mario would like to have extra servings (planned overage) of selected menu items available for sale. Using planned overage, the popularity index of his menu items, and his prior day's carryover information, help Mario determine the amount of new…

Your company is planning to borrow $2.75 million on a 5-year, 16%, annual payment, fully amortized term loan. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.                                                                                                              Amortization                       Loan amount $2,750,000         Term in years 5         Annual coupon rate 16.00%                     Calculation of Loan Payment   Formula       Loan payment =   #N/A                   Loan Amortization Schedule           Year Beginning Balance Payment Interest Principal Ending Balance 1           2           3           4           5                       Formulas           Loan Amortization Schedule           Year Beginning Balance Payment Interest Principal Ending Balance 1 #N/A #N/A #N/A #N/A #N/A 2 #N/A #N/A #N/A #N/A #N/A 3 #N/A…

Your father is 50 years old and will retire in 10 years. He expects to live for 25 years after he retires, until he is 85. He wants a fixed retirement income that has the same purchasing power at the time he retires as $45,000 has today. (The real value of his retirement income will decline annually after he retires.) His retirement income will begin the day he retires, 10 years from today, at which time he will receive 24 additional annual payments. Annual inflation is expected to be 5%. He currently has $180,000 saved, and he expects to earn 8% annually on his savings. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.                                                                                                       Required annuity payments               Retirement income today $45,000     Years to retirement 10     Years of retirement 25     Inflation rate 5.00%…