Philosophy homework help
Philosophy homework help. Question 1When writing the built in Excel formula for straight line depreciation you would start off the formula with=STL=SLN=(cost-salvage)/useful=$B$6, $B$8, $B$912 points Question 2When setting up a spreadsheet to calculate depreciation in Excel you should type in the cost of assetmultiple times since you need the cost to calculate depreciation for each year presentedmultiple times since you need the cost to calculate depreciation for each year presented and the cost changes each yearonly 1 time and use relative cell referencing in your depreciation formulasonly 1 time and use absolute cell referencing in your depreciation formulas12 points Question 3How do you calculate accumulated depreciation in Excel?=cost + salvage value=cost-salvage value/useful life=cost-accumulated depreciation of the prior year=cost-accumulated depreciation of the current year12 points Question 4What is the purpose of a depreciation summary as described in your text?to capture all similar assets by category to make it easier to prepare year end balance sheetsto capture all similar expenses by category to make it easier to prepare year end balance sheetsto capture all costs, depreciation, and accumulated depreciation for all assets to make it easier to prepare year end income statementsto capture all costs, depreciation, and accumulated depreciation for similar assets to make it easier to prepare year end financial statements12 points Question 5When writing the built in formulas for depreciation what other formulas does Excel have in addition to straight line depreciation?double declining balance and MACRSunits of productions and sum of the year’s digitsdouble declining balance and sum of the year’s digitsdouble declining balance and units of production12 points Question 6What additional arguments are added to the built in depreciation formulas when you change from straight line deprecation to another built in depreciation formula?costsalvage valueestimated lifeyear or period of time12 points Question 7When doing a comparison chart in Excel of the built in depreciation methods which one will show as a horizontal line?Double decliningMACRSStrainght lineSum of the yearsUnit of Production12 points Question 8Interpret the following formula: =If ( A1> B1, “X”, C1)If the value in cell A1 is less than the value in cell B1 enter in X if not enter in the value in cell C1If the value in cell A1 is greater than the value in cell B1 enter in XIf the value in cell A1 is less than the value in cell B1 enter in XIf the value in cell A1 is greater than the value in cell B1 enter in X if not enter in the value in cell C112 points Question 9Once you create a chart in Excel and later discover you want to change the series to a new location you have to start the entire chat process over again, this cannot be edited in your existing chart. True False
