| Home| Personal BLog| Compositions| Health Avenue| Places| UnEditedMe| Philippines| Monk|

Friday, May 6, 2011

What-If Analysis Memo: Business Value of an Excel Workbook

As based on Silver Coat Tourism Resort's Income and Expenditure Statement, a What-If Analysis was drawn. After studying the statement, the What-If analysis was administered by formulation of 2 case scenarios. The scenarios would concentrate on the Planned Direct expenses wherein different values would be assigned to this item and how the Net Profit Income of each profit generating centre would be affected. A comparison of the original planned expenses to the two case scenarios would be made as well as show the different net ncomes that they will actually provide. Table 1 is presented below:

Original Planned
Expenses Case Scenario 1 Case Scenario 2
Administration $72,500.00 $110,000.00 $52,000.00
Depreciation $61,250.00 $86,500.00 $63,000.00
Energy $46,000.00 $48,750.00 $31,500.00
Insurance $12,500.00 $32,450.00 $22,500.00
Maintenance $26,000.00 $38,000.00 $28,000.00
Marketing $52,250.00 $61,000.00 $60,000.00
Net Income $650,910.00 $544,710.00 $664,410.00

Table 1. Table showing Original Planned Expenses, Case Scenario 1 and 2 assigned expenses as well as Net Income yield of each category

As shown in Table 1, Case Scenario 1 was assigned higher planned expenses as compared to the original planned expenses. In comparison of both the values presented, it clearly shows that higher planned expenses would translate to lower net income. Therefore, when Case Scenario 1 is considered, it will result to a lesser net income since comparing it's net income value to the original planned expenses column will result to a decrease of $106,200.00.

Warning and Friendly Reminder: Plagiarism is a crime. This essay is here to give you an idea or guide you, not to be copied by you. You can look at the references and Works cited provided by this free academic essay and from that you can create your own. Be a smart student,be honest: look for free academic essays anywhere in the web or the Internet but don’t forget to make your own. There are so many free essays online as guides but please do your own. You can also utilize free plagiarism checkers available online.

Case Scenario 2 as a different approach, assigns values in a different manner. Some expenses were increased and other expense categories were decreased. This resulted to an increase in net income of $ 13, 500.00 which is equivalent to approximately 2%. Therefore, knowing which expenses to minimize and which ones to increase will definitely result to higher net income.
In conclusion, when a company puts effort on how to somehow minimize their indirect expenses it will definitely result to increase in net income. The company must employ the best means of decreasing their expenses in order for them to yield a higher profit.

Business Value of the Excel Workbook

The excel workbook is a tool that will help financial planners since it can help gauge the overall financial performance of a business when being faced with various modifiable constraints. The values placed on Planned Indirect Expenses are considered the modifiable variables. The indirect/operating expenses can be manipulated while keeping constant the Net Income, Cost of Sales and Direct Expenses. This way, the business can weigh the effects of the changes made in indirect expenses and they can work on ways on how these expenses be mnimized. In effect, the company profit is maximized. With the excel woorkbook, financial planners can determine the expense which should be monitored closely, which ones are to be minimized, how to effectively do it and what are the best expense allocation expense technics to be employed that will give positive results.

Business Value of the Excel Workbook

The excel workbook is a simple indirect expense allocation tool created to help foresee a business’ financial performance given a set of modifiable constraints. In this tool, the only modifiable variables are what you place on planned indirect expenses. Net Income, Cost of Sales and Direct Expenses are assumed to be constant while you play around with indirect/operating expenses. This can allow businesses to make mitigation plans to maximize their end profit. Such questions like (1) what expense type should closely be monitored, (2) where to cut cost, (3) how to effectively minimize unnecessary expenses and (4) what feasible expense allocation can yield the best results, are things that this workbook can help financial planners to answer.