Answer
The answer and procedures of the exercise are attached in the following archives.
Step-by-step explanation:
You will find the procedures, formulas or necessary explanations in the archive attached below. If you have any question ask and I will aclare your doubts kindly.
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
Answer: Data gap analysis.
Explanation:
A Data gap analysis occurs when an organization evaluates it's available data, and seek methods of improving data collection to meet up with business expectations. Data gap analysis is done to ensure that, an organization has the right information to enable them run operations effectively.
