26 Apr Determining the viability of long-term capital investments is a fundamental aspect of corporate accounting. In this assignment, you use Excel to make and interpret specified calculations f
3 Attempts AllowedAvailable after Apr 8, 2024 12:00amAvailable after Apr 8, 2024 12:00amDetails
Overview
Determining the viability of long-term capital investments 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] Download 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 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,000Facilities$600,000Annual Cash Flow (150 total yearly players' fees)$920,000Annual Cash Outflows$840,000Estimated Useful Life of Facilities20 yearsFacilities Salvage Value$1,500,000Discount Rate8%
This course requires the use of Strayer Writing Standards (SWS). The library is your home for SWS assistance, including citations and formatting. Please refer to the Library site for all support. 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.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.