Planning for capital investments overview determining the viability of a long term capital investment is a fundamental aspect of corporate accounting

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Week 4 Assignment -

Planning for Capital Investments Overview Determining the viability of a long-term capital investment is a fundamental aspect of corporate accounting. In this assignment, 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 Read the following scenario and use the Week 4 Assignment Template [XLSX] to complete this assignment. 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. Note that you must add functionality to the appropriate spreadsheets to make the proper calculations. Scenario Use the following to 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% This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course. Check with your professor for any additional instructions. The specific course learning outcome associated with this assignment is: Create financial reports, charts, graphs, and what-if analyses using Excel.

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme