The correct option is this: CHECKING SCENARIOS WITH VARIABLE DOWN PAYMENT.
A data table is a range of cells, which shows how changing one or two variables in one's formula can affect the value of that formula.
In excel, instead of creating several scenarios, one can create a data table with which one can quickly try out different values for formula.<span />
Answer:
The Bid Price you should submit is $15.45
Explanation:
NPV = -795000 + 143000*(1-21%)/1.09^5-70000 + 70000/1.09^5 + ((120000*(P-10.15) - 435000 - 795000/5)*(1-21%) + 795000/5)/0.09*(1-1/1.09^5)
=> -795000 + 143000*(1-21%)/1.09^5 - 70000 + 70000/1.09^5 +((120000*(P-10.15) - 435000 - 795000/5)*(1-21%) + 795000/5)/0.09*(1-1/1.09^5) >=0
=>P = 15.446118865171
Therefore, The Bid Price you should submit is $15.45
Continually reassess your plan. As part of the investment process and financial planning process, Holly should monitor and reassess her savings and investing plan annually to determine if her goals have changed and if she is meeting her goals through the plan's performance.
Answer:
Collected on domestic economic activity
Explanation:
apex
