Finance Assignment For Mrs Lynn Only
Instr
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