The following is required for the fourth requirement of the case study:

Use the prepared template to develop a revised cash budget for MTI for the 2001-2002 fiscal year. Note that the spreadsheet model incorporates Billy Young’s assumptions that (1) the entire impact of the $199,000 reduction in revenues in Exhibit 6 occurs in September, and (2) that the salary increase and new hire are off the table until fiscal year 2002.  If you make changes in staffing, be prepared to justify your decisions, given the potential impact of layoffs on MTI’s ability to respond when business recovers.  You may use the template to:

  1. Manipulate post 9/11 revenues using best case, worst case and middle ground scenarios.
  2. Eliminate or reinstate the incentives for salaried employees.
  3. Defer some proportion of fixed salaries; any deferred compensation will appear as a liability on MTI’s 8/31/2002 balance sheet.
  4. Defer some portion of the rent on the Seattle office; any deferred rent will appear as a liability on MTI’s 8/31/2002 balance sheet.
  5. Lay off up to eight salaried employees.

Decisions about retaining or eliminating the new hire at $35,000 per year are controlled entirely by the macros.  The “original revenue” and “reinstate incentives” scenarios retain the new hire.  All other scenarios assume the new hire is eliminated.

Don't use plagiarized sources. Get Your Custom Essay on
The following is required for the fourth requirement of the case study:
Just from $13/Page
Order Essay

Be sure to follow the instructions in the supplemental excel files when completed the work for requirement 4.  You should provide a detailed discussion regarding why you made the choices that you did, it is not enough to simply submit the excel file.


Unlike the other case studies, this one takes a complex financial model and simplifies things greatly with the use of macros.  

The discussion for this requirement can be completed in a word document.  To help me understand your conclusions for the  requirement, go ahead and submit the excel file with your word file as well.

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.
error: Content is protected !!
Live Chat+1(978) 822-0999EmailWhatsApp

Order your essay today and save 20% with the discount code GOODESSAY