Finance Assignment For Mrs Lynn Only
ricanfinest
CapitalBudgetingProjectTemplatedueMondayNov.16.xlsmInstr
| Capital Budgeting Project | ||||||||
| Last Name | First Name | ID | ||||||
| Click the button below to begin this assignment. | ||||||||
| This is a graded assignment. Do your own work (required). Do not, for example, copy the work of others. | ||||||||
| <= "CF Analysis" worksheet should be available after selecting "Begin Work" and inputting requested info | ||||||||
| If the button does not work, reopen this file and select "enable macros" or "enable content". | ||||||||
| Please note that aspects of your work are catalogued to ensure academic integrity. |
Begin Work
CF Analysis
| Mold # | Capital Budgeting Project | ||||||
| Original Cost of Old Asset | Last Name | First Name | Banner ID | ||||
| Cost of New Asset | |||||||
| Market Value New Asset Year 5 | Do not insert, delete, move, merge or name any rows, columns, or range. | ||||||
| Market Value Old Asset Time 0 | Do all of your work ONLY by using formulas in the beige cells | ||||||
| Market/Salvage Value Old Asset Year 5 | Do no work outside of those ranges, except to enter input values in the yellow cells | ||||||
| Current Age of Old Equipment | Program each cell to show the correct sign based on the cash flow impact of the number. All subtotals MUST be a SUM. | ||||||
| Depreciable Life of Old Equipment | Write your formulas so that they will work for ANY numbers entered in the yellow cells. | ||||||
| Increase (Decrease) in Current Assets | Accept/Reject should be programmed to show exactly the word Accept or Reject reflecting your decision on this project. | ||||||
| Increase (Decrease) in Current Liabilities | Payback & Discounted Payback formulas do not need to work for any project, just for your project and any other that would payback in that same year. | ||||||
| Increase (Decrease) in Revenue | Payback & Discounted Payback should NOT be text, unless it does not payback in which case the text should read "NEVER". | ||||||
| Increase (Decrease) in Expenses | |||||||
| Marginal Tax Rate | MACRS RATES | ||||||
| Required Return | |||||||
| Depreciation | Previous Years Acc. Depr. | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | |
| Depreciation Old Equipment | |||||||
| Book Value Old | |||||||
| Depreciation New Equipment | |||||||
| Book Value New | |||||||
| Year | 0 | 1 | 2 | 3 | 4 | 5 | Formula |
| Revenue | |||||||
| Expenses | |||||||
| Depreciation | |||||||
| EBIT | |||||||
| Taxes | |||||||
| Net Income | |||||||
| Depreciation | |||||||
| OCF | |||||||
| ATSV: Sale of Old Asset | ATSV: Lost Sale of Old Asset | ||||||
| Cost of New Asset | ATSV: Sale of New Asset | ||||||
| Increase in NWC | NWC Reversal | ||||||
| Net Initial Investment | CFFA | ||||||
| Accept/Reject? | NPV | IRR | Profitability Index | Payback | Discounted Payback | ||
|
Chris McNeil: x:y:z:9831811785 |
Chris McNeil: x:y:z:9831811785 |
Chris McNeil: x:y:z:9831811785 |
Chris McNeil: x:y:z:9831811785 |
intsetup
| Setup for Integrity Macro - - worksheet in student file | Click the "Hide Sheets" button before releasing file to students. | ||||
| Recommendations: Release a renamed copy of this file to students. | |||||
| mode (instructor or student) | student | File for students must have an "xlsm" extension. | |||
| password - - for worksheet protection | 54321 | ← Make a note of this password before selecting "Hide Sheets." Password required to "unhide." | |||
| student info - recorded after supplied by student | |||||
| initial visible worksheet | Instr | ||||
| worksheets on which to display student name, ID | CF Analysis | Instr | |||
| student LAST NAME - - cell address in which to display | d3 | g3 | |||
| student FIRST NAME - - cell address in which to display | e3 | h3 | |||
| student ID - - cell address in which to display | f3 | i3 | |||
| protect worksheets (yes, no) on which to display student name, ID (yes or no) | yes | yes | |||
| Integrity Code - - 10 digit random number generated by Excel for the student | |||||
| worksheets to release to students | CF Analysis | ||||
| worksheets to remain hidden (never release) | intsetup | recordedWkbks | |||
| cells for hidden comment markers | |||||
| worksheet | CF Analysis | ||||
| cells | c23:g32,b34:g34, b16:g19 | ||||
| randomize values | |||||
| worksheet | |||||
| cells | |||||
| up to "x" % higher (e.g., 15.0 for up to 15% higher) | |||||
| down to "x" % lower (e.g., -12.0 for as much as 12% lower) | |||||
| rounding (e.g., 1000 for thousands; and 0.01 for 2 decimal places) | |||||
| worksheet for recording of activated Excel files (cannot change) | recordedWkbks | ||||
| Macro has run indicator (= TRUE after run) | 0 | ||||
Hide Sheets
