Your Company is thinking of acquiring another corporation.You have two choices; the cost of each choice is $250,000. You cannot spend more than that, so acquiring both corporations is not an option, the following are the critical data;
Corporation A:
Revenues = 100K in year one, increasing by 10% each year
Expenses = 20K in year one, inxreasing by 15% each year
Depreciation Expense = 5K each year
Tax Rate = 25%
Discount Rate = 10%
WRITE THIS ESSAY FOR ME
Tell us about your assignment and we will find the best writer for your paper.
Get Help Now!Corporation B
Revenues = 150K in year one, increasing by 8% each year
Expenses = 60K in year one, increasing by 10% each year
Depreciation Expense = 10K each year
Tax Rate = 25%
Discount Rate = 11%
Compute and analyze items (a)-(h) using a Microsoft Excel Spreasheet. Ensure all calculations can be seen in the background of the applicable spreadsheet cells (leave an audit trail for others to see how you arrived at your answers).
a) calculate a 5-year Projected Income Statement (sheet one in my spreadsheet)
b) calculate a 5-year Projected Cash Flow (sheet 2)
c) calculate Net present Value (sheet 3)
d) calculate the Internal Rate of Return (sheet 4)
e) Based on items (a) through (d), which company would you recommend acquiring?
Introducing our Online Essay Writing Services Agency, where you can confidently place orders for a wide range of academic assignments. Our reputable homework writing company specializes in crafting essays, term papers, research papers, capstone projects, movie reviews, presentations, annotated bibliographies, reaction papers, research proposals, discussions, and various other assignments. Rest assured, our content is guaranteed to be 100% original, as every piece is meticulously written from scratch. Say goodbye to concerns about plagiarism and trust us to deliver authentic and high-quality work.
WRITE MY ESSAY NOW
