Parti Use Microsoft Excel for solving the Problem [60 marks] 1. A Furniture Manufacturing Company has purchased new furniture for their offices at. a retail price of $125.000. An additional $20,000 has been charged for insurance shipping, and handling. The company expects to use the furniture for 10 years. (useful life = 10 years) and then sell it at a salvage (market) value of $15,000. Compute the solution for the below mentioned questions using the following methods of depreciation Straight line(SL), Sum of Years Digit (SOYD). Declining balance (DB) Double declining balance (DDB) (iii) (10) What is the depreciation during the second year in each case What is the BV of the asset after 10 years in all the cases (attach the excel sheet) Draw the cash flow diagram for SL method for 10 years. Part 2 Derivation of equation [40 marks] Derive the Equation for Bond Pricing or formula for Bond valuation Compare different methods of valuing a stock use a table to compare)