Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

pls answer in excel A new renewable energy company, Genifuel, is building its first plant in the Orlando area where algae farms will turn sunlight

pls answer in excel image text in transcribed
A new renewable energy company, Genifuel, is building its first plant in the Orlando area where algae farms will turn sunlight into automotive biofuel. Sergio, an IE working for Genifuel, has been tasked to evaluate a project with a 10-year horizon (analysis period). Genifuel seeks a MARR of 10.71%. The federal corporate income tax rate is 21.00%, and Florida's state corporate income tax rate is 5.5%. Project: Initially, the green technology equipment (a 7-year property class, but a useful life of 10 years) will cost $41.6 million. First-year annual operating costs will be $28.6 million and increase each year after that by $350,000. This plan will produce biofuel worth $183.6 million in revenue the first year and will decrease in revenue by 6% each year thereafter. Answer the following questions in your Excel file: Question A) What is the Cost Basis, B, of the green technology equipment? Enter your answer in US dollars rounded to 2 decimal places. Do NOT enter any spaces, commas, or dollar sign (\$). Just enter the numeric value. If the number is negative, put a - sign in front of the number without any space. Question B) Calculate the MACRS Depreciation in Year 3 for the green technology equipment. Show your work/calculations in vertical columns in Excel. Enter your answer in US dollars rounded to 2 decimal places. Do NOT enter any spaces, commas, or dollar sign (\$). Just enter the numeric value. If the number is negative, put a - sign in front of the number without any space

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Artificial Intelligence In Accounting Practical Applications

Authors: Cory Ng, John Alarcon

1st Edition

0367542013, 978-0367542016

More Books

Students also viewed these Accounting questions