Question

Chief Financial Officer of a company is developing sales projections for each quarter of the

forthcoming year. She knows what the company’s total income must be for the year to satisfy

stockholders. She also has a good idea of the Working backwards company’s income in the first

three quarters, because of the contracts that are already signed. For the fourth quarter, however,

no definite income is available. So how much must the company earn in Q4 to reach its goal?

Secondly she also wants to calculate different interest rates on an investment done (4)

a. Which feature in open office calc should be used to achieve its goal in Q4.

b. Under which menu option that following feature available.

c. For calculating different interest rates on an investment done.Which feature ?

d. How solver is different from goal seek​

Answer 1

A is the answer of your Questions