Xavier Company contracted for the purchase and installation of a large printer which costs P250,000. This amount includes freight and installation charges estimated at 10% of the above contract price. If the printer shall be depreciated over a period of 10 years with a salvage value of P15,000 and money is worth 6% per annum, what is the annual depreciation charge using SFM? A. P19,725.67 B. P19,257.50   C. P17,070.29   D. P17,828.97

Big Sky Mining Company must install $1.5 million of new machinery in its Nevada mine. It can obtain a bank loan for 100% of the purchase price, or it can lease the machinery. Assume that the following facts apply:   The machinery falls into the MACRS 3-year class. (The depreciation rates for Year 1 through Year 4 are equal to 0.3333, 0.4445, 0.1481, and 0.0741.) Under either the lease or the purchase, Big Sky must pay for insurance, property taxes, and maintenance. The firm's tax rate is 25%. The loan would have an interest rate of 14%. It would be nonamortizing, with only interest paid at the end of each year for four years and the principal repaid at Year 4. The lease terms call for $420,000 payments at the end of each of the next 4 years. Big Sky Mining has no use for the machine beyond the expiration of the lease, and the machine has an estimated residual value of $200,000 at the end of the 4th year.   What is the cost of owning? Enter your answer as a positive value. Do not…

Paragon Properties built a shopping center at a cost of $50M in year 2010. The company started leasing space in July of 2014. The land was purchased for $5M. Determine the depreciation charges through 2017 if the property was sold in November 2017. $4,615,200 $5,002,200 $3,563,100 $3,991,050

Can you please show me how to do these parts on excel? I have included the solutions to the parts, but I need to see how it is done with the formulas/equations on Excel, so I can fully understand what is going on. Thank you in advance!