120 f_(x) Formula: Subtract, Multiply; Cell Referencing BE12.9 Using Excel to Account for Investments Using Multiple Methods PROBLEM Chan Inc., a publicly traded company, purchased Dong Ltd.'s common shares for January 1. During the year, Dong reported net income declared and paid dividends. The following information pertain to the investment. Percentage of shares purchased 20% Cost of acquisition $225,000 Net income reported by Dong during the year 350,000 Dividends paid by Dong during the year 40,000 Investment's fair value at December 31 275,000 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area and work area as indicated. Determine the accounts and bal