You can use excel to create one
Answer:
Stock markets are one of the factors that affect the economy, but there are others as well. Consumer spending and business investment slows down, which reduces economic growth. Falling interest rates can stimulate economic growth. Fiscal policy decisions also can affect the economy.
Answer:
In 269th Payment the principal component is greater than half of the payment
Explanation:
Amortization schedule is attached please find it.
The loan payment includes the interest and principal portion. After deducting the interest on the due balance the residual amount is paid towards the principal.
Loan is paid per month, the amount of each payment can be calculated as follow:
Loan Payment per month = r ( PV ) / 1 - ( 1 + r )^-n
r = rate per period = 9% per year = 0.75% per month
n = number months = 30 years x 12 months per year = 360 Months
PV = present value of all payments = $420,000
P = payment per month = ?
P = 0.75% ( $420,000 x 90% ) / 1 - ( 1 + 0.75% )^-360
P = $3,041.47 per month
The what-if analysis tool would be the most adequate choice for intricate calculations that need contrived optimization:
b). Scenario manager
- 'What-if analysis tool' is described as the tools that are employed to alter the values present in the cells.
- It is done to observe the effect of changing the values impact the results produced by the used formula.
- The what-if analysis tools have been categorized into three distinct types:
- a). Scenarios.
- b). Goal Seek.
- c). Data Tables.
- As per the question, in order to opt for complex calculations, 'Scenarios' what-if analysis would be most adequate as they examine a number of variables and set of numbers/values that affect the outcome.
Thus, <u>option b</u> is the correct answer.
Learn more about 'what-if tool' here:
brainly.com/question/14830872
