I have to solve the following problem using the excel document below:

The previous financial manager had been evaluating the cash flows of a proposed project. The present value of the following cash stream is $9,300 when discounted at 10%.

Year 1 - Cash Flow $1,800

Year 2 - Cash Flow _______?

Year 3 - Cash Flow 2,900

Year 4 - Cash Flow 3,100

Fill in the values in the spreadsheet.

M3 Scenario-1_Student Template (4) View Comments AutoSaveFF AESU Home Insert Draw Page Layout X Arial 10 Peste 3 BIU - A1 xv fx Formulas A A A Data = Review = = hin Wraa Text Merge & Center General S -% 2nsert 28 Delete Farmat Share EAY-O. 4 J X Sort Find X Ideas Filter Select E -3 Sensitivity Formatting es Table Styles Inpularea: PV of cash flows Year 9.300 Cash flow 1,800 2,900 3,100 Discount rate 10% Cutour area: Year Total PV of missing CF Value of missing CF C Sim la Sim 1b Sim 10 Sim 1d Sim 10 + # 2 - + 100%