Please use excel while solving this

the game Jealea designed a video game! They were able to raise $ 100,000 from investors to get to market. Below are the costs which Jaelea incurred in the first 5 years of production. Computer for development (with a super fancy graphics card) $9,800 o This device can 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 $60 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 $6,500 per year. The first year the games was available for purchase it sold 350 copies. In year 3 it sold 1,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 5 years of the business. This includes the first 5 year when there are no sales. Since the game was considered a 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 years in which they have a loss. Meaning the taxes paid are o$ for that year. You are in Florida and therefore there is no state tax. You will pay taxes based on the federal tax bracket below. Taxable Income $0 - $50,000 $50,001 - $75,000 $75,001 - $100,000 $100,001 - $335,000 $335,001 - $10 Million $10 Million - $15 Million > $15 Million Tax Rate 15% 25% 34% 39% 34% 35% 38% b. What is the IRR of the investment of the $100,000 investment? Do not include any payment back to investors C. They paid the investor back after 5 years. The investor earned 10% interest per year Jaelea kept their funds. Using future value analysis (i-4%) what is Jaelea's total profit over the 5 years after paying back the investors? 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. at 1. Formatting Tables: Is it easy to follow your spread sheet? The TA should be able to look your sheet and by column titles and formulas in the cells understand what you did. 2. Depreciation 3. BTCF 4. Federal Tax 5. ATCF 6. IRR of Investment (and interpretation) the game Jealea designed a video game! They were able to raise $ 100,000 from investors to get to market. Below are the costs which Jaelea incurred in the first 5 years of production. Computer for development (with a super fancy graphics card) $9,800 o This device can 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 $60 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 $6,500 per year. The first year the games was available for purchase it sold 350 copies. In year 3 it sold 1,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 5 years of the business. This includes the first 5 year when there are no sales. Since the game was considered a 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 years in which they have a loss. Meaning the taxes paid are o$ for that year. You are in Florida and therefore there is no state tax. You will pay taxes based on the federal tax bracket below. Taxable Income $0 - $50,000 $50,001 - $75,000 $75,001 - $100,000 $100,001 - $335,000 $335,001 - $10 Million $10 Million - $15 Million > $15 Million Tax Rate 15% 25% 34% 39% 34% 35% 38% b. What is the IRR of the investment of the $100,000 investment? Do not include any payment back to investors C. They paid the investor back after 5 years. The investor earned 10% interest per year Jaelea kept their funds. Using future value analysis (i-4%) what is Jaelea's total profit over the 5 years after paying back the investors? 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. at 1. Formatting Tables: Is it easy to follow your spread sheet? The TA should be able to look your sheet and by column titles and formulas in the cells understand what you did. 2. Depreciation 3. BTCF 4. Federal Tax 5. ATCF 6. IRR of Investment (and interpretation)