How financial modelling techniques can be used by CPA?
Title: How financial modelling techniques can be used by CPA?
Category: /Business & Economy
Details: Words: 839 | Pages: 3 (approximately 235 words/page)
How financial modelling techniques can be used by CPA?
Category: /Business & Economy
Details: Words: 839 | Pages: 3 (approximately 235 words/page)
Microsoft Excel enables user to recalculate complete spreadsheet quickly to evaluate different outcomes. There are some modeling techniques that user can use as a comparison for making financial decisions from several variables (Presto, pg. 326). They are Sensitivity analysis, goal seeking and sensitivity analysis.
I.<Tab/>Sensitivity Analysis
Sensitivity analysis is "a process of analysis the changing of a single variable in a small increments or decrements to see how sensitive model
showed first 75 words of 839 total
You are viewing only a small portion of the paper.
Please login or register to access the full copy.
Please login or register to access the full copy.
showed last 75 words of 839 total
table, Excel substitutes a series of different values for two input values in a formula (Harvey, 620). These are steps that to do the sensitivity analysis by using Data Table, as shown below.
1.<Tab/>Construct the formula for the monthly payment of the loan.
2.<Tab/>Select the cells that will be used for the table which include the term range and the interest rate range in the table.