Create financial reports charts graphs and what-if analyses

Assignment Help Financial Accounting

Reference no: EM133682923

Homework: Planning For Capital Investments

Overview

Determining the viability of long-term capital investments is a fundamental aspect of corporate accounting. In this homework, you use Excel to make and interpret specified calculations for a capital investment analysis that includes sensitivity and what-if analyses for a proposed football training facility.

Instructions

1) Read the following scenario and use the Homework Template [XLSX] to complete this homework.

2) Specific directions are included in the template. Make sure to complete all tabs for Parts 1 and 2 and follow the directions given in each.

3) Note that you must add functionality to the appropriate spreadsheets to make the proper calculations.

Scenario

Use the following scenario for your work:

Kicking It Corp. is planning to open a football camp in Arizona, which will require a land purchase and facilities development that includes fields, sleeping and dining facilities, maintenance equipment, and other capital expenditures. Each year, the camp will run for eight one-week sessions. The company will also incur operational expenses.

The estimates in the following table have been shared with company leadership and investors:

Estimated Figures

Item                                                                   Amount
Land                                                                   $300,000
Facilities                                                               $600,000
Annual Cash Flow (150 total yearly players' fees)     $920,000
Annual Cash Outflows                                           $840,000
Estimated Useful Life of Facilities                             20 years
Facilities Salvage Value                                           $1,500,000
Discount Rate                                                       8%

The specific course learning outcome associated with this homework is:

Create financial reports, charts, graphs, and what-if analyses using Excel.

Reference no: EM133682923

Questions Cloud

Discuss the reasons and goals of the law : Discuss the reasons and goals of the law. Discuss how the various sources of law might interact or affect one another. Discuss how the law changes.

Balance rights and obligations in contemporary australia : Conducting a literature review on the need to balance 'rights' and 'obligations' in contemporary Australia.

Context of seeking family violence protection : The location and role of the local court in the context of seeking a family violence protection order in Australia;

Civil rights act to promote health equity : Discussing how to apply the Fourteenth Amendment to the Constitution and the Civil Rights Act to Promote Health Equity in the US

Create financial reports charts graphs and what-if analyses : Make sure to complete all tabs for Parts 1 and 2 and follow the directions given. Create financial reports, charts, graphs, and what-if analyses using Excel.

Write a research paper about insurance fraud : Write a research paper about Insurance Fraud. Describe how fraud occurs and how it can be prevented and detected.

What is the outcome if management fails to consider benefits : What is the outcome if management fails to consider the intangible benefits of a capital budgeting decision?

Description of the criminal justice policy : A description of the criminal justice policy you selected. An explanation of how the policy might be beneficial to your audience.

Discuss why you think policy commitments may be suspected : After careful analysis, discuss why you think policy commitments may be suspected of undue influence rather than responding to citizen needs?

User Account

All Pages