You can use excel

Problem 4 - Depreciation & ATCF Jealea designed a video game! Below are the costs which Jaclea incurred in the first 5 years of production. . Computer for development (with a super fancy graphics card) - $10,300 o This device can be depreciated using MACRS depreciation. The computer is a 3- yr property class. The first year was for development only, meaning no games are sold. The game was available for $15 in the Steam store in the first year it is sold (aka year 2), while the bugs are worked out. It was then sold for $50 every year after. Marketing did not occur in the first year of development or second year of beta testing. However, starting in year 3 marketing costs were $8,000 per year. The first year the game was available for purchase it sold 350 copies. In year 3 it sold $500 copies, in year 4 it sold 4,000 copies and in year 5 it sold 7,500 copies. a. Create the ATCF table for the first $ years of the business. This includes the first year when there are no sales. Since the game was considered a start-up Jealea qualified for a special program that actually allows them to only pay taxes on profit. They do not receive tax credit for the years in which they have a loss. Meaning the taxes paid are 0$ for that year. There is no state tax to consider. You will pay taxes based on the federal tax bracket below. VERSION A Final Exam Summer 2023 Taxable Income Tax Rate $0 - $50,000 15% $50,001 - $75,000 25% $75,001 - $100,000 34% $100,001 - $335,000 39% $335,001 - $10 Million 34% $10 Million - $15 Million 35% > $15 Million 38% Here are the specific parts we will look for when grading. This should also help you to include all of the parts of the problem. 1. Formatting Tables: Is it easy to follow your spread sheet? The TA should be able to look at your sheet and by column titles and formulas in the cells understand what you did. 2. Depreciation 3. BTCF 4. Federal Tax 5. ATCF