Production Expense Product Development Capital Expenses Overhead Total Expenses

Document Sample
Production Expense Product Development Capital Expenses Overhead Total Expenses Powered By Docstoc
					   Palisade Corporation                                                                    Template.xls (Finance.xls with a user defined template) Example Model



@RISK User-Defined Templates
Finance.xls with a User-Defined Template
This model demonstrates the use of @RISK's user-defined template reports. A template report allows you to
create a simulation report directly in Excel that contains only the specific information that you are interested in.
To use a template you first create a template sheet which contains one or more @RISK statistic and/or graph
functions. Make sure the name of the template sheet starts with "RiskTemplate_". When you generate your
@RISK reports, make sure to select the "Template Sheets" option. A copy of the template sheet will be made
replacing all functions with values. This "freezes" the report so that future simulations will not overwrite the
results that were just created. In this way, you can run many simulations with a corresponding copy of the
template sheet for each one.




NPV (10%)                           #NAME?

Year                                  2013                2014                2015                2016                  2017              2018              2019

Cash Flow
Total Revenue                   $             -     $             -         #NAME?              #NAME?                 #NAME?            #NAME?            #NAME?
Cost of Goods Sold              $             -     $             -         #NAME?              #NAME?                 #NAME?            #NAME?            #NAME?
Gross Margin                    $             -     $             -         #NAME?              #NAME?                 #NAME?            #NAME?            #NAME?
Operating Expenses                  #NAME?              #NAME?              #NAME?              #NAME?          $        20,000.00   $     20,000.00   $     20,000.00
Earnings Before Taxes               #NAME?              #NAME?              #NAME?              #NAME?                 #NAME?            #NAME?            #NAME?
Tax Basis                           #NAME?              #NAME?              #NAME?              #NAME?                 #NAME?            #NAME?            #NAME?
Income Tax                          #NAME?              #NAME?              #NAME?              #NAME?                 #NAME?            #NAME?            #NAME?
Net Income                          #NAME?              #NAME?              #NAME?              #NAME?                 #NAME?            #NAME?            #NAME?

Market Conditions
Number of Competitors                                                           0               #NAME?                 #NAME?            #NAME?            #NAME?
Unit Cost                                                                    $23.25              $24.41                 $25.63            $26.91            $28.26
Inflation Rate                                                                 5%                  5%                     5%                5%                5%
Tax Rate                              46%                 46%                 46%                 46%                    46%               46%               46%

Sales Activity
Sales Price                                                                  $58.13             #NAME?                 #NAME?            #NAME?            #NAME?
Sales Volume                                                                #NAME?              #NAME?                 #NAME?            #NAME?            #NAME?

Production Expense
Product Development                 #NAME?              #NAME?              #NAME?          $           -       $              -     $           -     $           -
Capital Expenses                    #NAME?              #NAME?              #NAME?              #NAME?          $              -     $           -     $           -
Overhead                        $             -     $     10,000.00     $     20,000.00     $     20,000.00     $        20,000.00   $     20,000.00   $     20,000.00
   Palisade Corporation                              Template.xls (Finance.xls with a user defined template) Example Model
Total Expenses            #NAME?   #NAME?   #NAME?        #NAME?        $      20,000.00   $     20,000.00   $      20,000.00
      Palisade Corporation                            Template.xls (Finance.xls with a user defined template) Example Model




     2020              2021              2022


    #NAME?            #NAME?            #NAME?
    #NAME?            #NAME?            #NAME?
    #NAME?            #NAME?            #NAME?
$     25,000.00   $     25,000.00   $     25,000.00
    #NAME?            #NAME?            #NAME?
    #NAME?            #NAME?            #NAME?
    #NAME?            #NAME?            #NAME?
    #NAME?            #NAME?            #NAME?


    #NAME?            #NAME?            #NAME?
     $29.67            $31.16            $32.72
       5%                5%                5%
      46%               46%               46%


    #NAME?            #NAME?            #NAME?
    #NAME?            #NAME?            #NAME?


$           -     $           -     $           -
$           -     $           -     $           -
$     25,000.00   $     25,000.00   $     25,000.00
    Palisade Corporation                        Template.xls (Finance.xls with a user defined template) Example Model
$   25,000.00   $   25,000.00   $   25,000.00
                                RiskTemplate_Report



Simulation Report for Finance Model
Date of Simulation                    7/30/2012

NPV Results
                                                  #NAME?
                 Statistic          Value
                   Mean            #NAME?
                  StdDev           #NAME?
                Skewness           #NAME?
                 Kurtosis          #NAME?
              5th Percentile       #NAME?
              95th Percentile      #NAME?




Ten Year Trend
                                                  #NAME?
                     Year #      Mean Income
                      2013         #NAME?
                      2014         #NAME?
                      2015         #NAME?
                      2016         #NAME?
                      2017         #NAME?
                      2018         #NAME?
                      2019         #NAME?
                      2020         #NAME?
                      2021         #NAME?
                      2022         #NAME?




                                      Page 5
RiskTemplate_Report




      Page 6

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:66
posted:7/30/2012
language:English
pages:6