The Company has one asset. The asset has a three-year life and two possible payoffs each year: 1) $750 with a probability of40%, and 2) $100 with a probability of 60%. The company depreciates assets using the straight-line method. Assume the states between years are independent, an interest rate of 6%, and state 1 is realized in year 1. Using Excel, prepare a spreadsheet to show the balance sheet, income statement, and residual income / goodwill analysis for year. I have provide two attachments, one attachment includes detail for the Excel assignment and the other is an example of what the Excel should look like and include the same concepts.
Paper#9730 | Written in 18-Jul-2015Price : $25