Fixed Asset Project(mainly calculate depreciations)
In July of 2019, Destiny Freebird opened her own interior design business. To get started her first year, she needed some equipment. She purchased the following assets: an industrial sewing machine, a delivery vehicle, two large craft tables, a large shelving system, a laptop computer, three computer monitors, a printer and professional interior design software. These items, with their costs and purchase dates are listed on the depreciation schedule included. You will also need to recalculate the depreciation for the warehouse she purchased, and the home office.You will need some additional information to complete the depreciation schedule. Destiny purchased the warehouse for $200,000. Destiny paid $20,000 as a down payment and financed the remaining $180,000. The tax appraisal showed the tax assessment for the property to be $125,000. The building was assessed at $93,750 and the land was assessed at $31,250. Legal fees incurred to purchase the property were $3,200. Destiny purchased the home for $200,000, and it had a fair market value in 2019 of $200,000. The tax appraisal for the entire property was $150,000. The building was assessed at $112,500 and the land was assessed at $37,500. The home office is 500 square feet while the house is 2000 sq. ft total.For both of these properties, you should allocate the purchase price or fair market value by the tax assessment ratio to find the amount of the purchase price/fair market value that corresponds to the building and the land. Remember that land is not depreciable. Normally, it would be included in the depreciation schedule and not depreciated. You should not include the land in this schedule. The delivery vehicle is a 2019 Ford Transit Connect, white with pink and purple racing stripes. (These came standard, at no additional cost.) The cost of the vehicle was $27,999. Destiny would also like to know the effect depreciation will have on her business income in the future. While she would love to reduce her taxable income for 2019 down to zero, she knows that may not be a good idea. She currently feels as though her 2019 asset purchases will work for her for several years and she is not currently planning any major asset purchases for the next two years at least. Required:Complete the related Fixed Asset Schedule for Magaliscious D’s. Use Section 179 and bonus depreciation to depreciate the assets for 2019-2020. You will need to think of your client’s future needs (explained above) and help her make decisions that will serve her well now and in the future. If you need information past that available in you in your text, the IRS has a publication covering depreciation of assets that may be useful. Columns 3-7 have dropdown boxes, much like a depreciation schedule you would see in traditional tax software. Please use the drop down boxes. (In other words, do not type over them.)I would recommend using formulas in excel to calculate the depreciation on your assets. You can search values online for table MACRS Half-Year Convention, MACRS Mid-Quarter Convention, Residential Rental Property Mid-Month Convention Straight Line—27.5 Years, Nonresidential Real Property Mid-Month Convention Straight Line—31.5 Years (for assets placed in service before May 13, 1993) .Please format the excel schedule to one page.