Here is the full assignment description: capital budget utilizing Microsoft Excel. You can use budgeting numbers from a publicly-traded company or the company you work for. Based on your budget analyze the strategic direction the company is going and your recommendations to increase profit, as a finance manager.

Length: 1 Excel Worksheet and a Word document

References: Include a minimum of 5 scholarly resources.

The completed assignment should demonstrate thoughtful consideration of the ideas and concepts presented in the course by providing new thoughts and insights relating directly to this topic. The content should reflect scholarly writing and current APA standards and should adhere to Northcentral University's Academic Integrity Policy."

Here is a copy of what I have in my Excel spreadsheet with data for a UPS hub that was built and my own estimates of payback, NPV, and IRR:

Year 0: Cash Flow: $275,000,000 Cumulative Cash Flow: Payback: 0

Year 1: $30,000,000 - $245,000,000 1

Year 2:$30,000,000 - $215,000,000 1

Year 3:$30,000,000 - $185,000,000 1

Year 4:$30,000,000 - $155,000,000 1

Year 5:$30,000,000 - $125,000,000 1

Year 6:$30,000,000 - $95,000,000 1

Year 7: $30,000,000 - $65,000,000 1

Year 8:$30,000,000 - $35,000,000 1

Year 9:$30,000,000 - $5,000,000 1

Year 10:$30,000,000 + $25,000,000 1

Payback Period: 9.16 Years Cost of Capital 15% (I was allowed to choose any cost of capital I wanted within reason).

NPV $17,312,500 Any value greater than zero brings value

IRR = 16% 15.88%