The second project expands the spread sheet adding columns to the initial two from project 1. The project should have rows for each year including year zero, a row for each of the 10 years, and then a total row for checking values. The column titles are given below, but you can abbreviate them and put them on multiple lines as indicated on the sheet sent previously.
? 125% Zoom T Insert . Chart I Text View Table Shape Media Comment Share Tips Format Document Text Body Update Update Amount Interest Start Year Loan Period Investment Life Depreciation Method Style Layout More Loan 1 Investment 1 Investment 2 MARR = 15% 60,000 70,000 30,000 Tax Rate = 25% MACRS-GDS MACRS-ADS-SL Font Trebuchet MS (Calibri) 11 pt Column Titles 1 Year 2 Total Revenues 3 Total Expenses 4 CFBT 5 Investment 6 Loan Cash Flow 7 CFAL 8 Loan Principal 9 Loan Interest 10 Depreciation Rate - Investment 1 11 Depreciation Amount - Investment 1 12 Depreciation Rate - Investment 2 13 Depreciation Amount - Investment 2 14. Taxable income 15. Taxes Paid(TP) 16. Net Profits(NP) 17. Cumulative Net Profits 18. CFAT - Method 1(CFAL - TP) 19. Cumulative CFAT-1 20. CFAT - Method Z(NP.Depreciation - Loan Principal - Investment (only for Investments after year 0) 21.Cumulative CFAT-2 (should be identical to Column 19) 22. Discounted Net Profits(NP) 23. Cumulative Discounted NP 24. Discounted CFAT 25. Cumulative Discounted CFAT B v Character Styles Character Style Alignment Show what checks from the totals you used to assure that you had the correct answers. The TEAM report cover page will include the names of the team members and the team name & number and be submitted electronically for grading and to all the team members. Designate who will send the team report. Individual reports must be submitted by each team member. E Spacing 1.0 - Single Bullets & Lists None 0 109% Zoom ul Chart T Text View Formula Table Shape Media Comment Share Tips Format Sort & Filter Sheet1 Table Cell Text Arrange G H I J K L M N O P Q R S T U V W X Matrta including: Revenues, Expenses, Investments CFDT, Loan Cash Flow, CFAL. Loan Principal, Loan Interest, Depreciatianicach investment). Taxable income Tases Paid, Net ProfitsiNP), Cumulative NP. CFAT, Cumulative CFAT, Discounted NP. Cumulative Discounted NP. Discounted CFAT, and Discountel CFAT Loan Interest Start Payment can life Sar! Date Der wechad Makitional Information Amt-$ Rate Date Start Y Table Styles 6 0 Loan Annual Payment PMP Amount 60,000 12201.5 $114.6657 Investment - 1 Investment- 2 Amount 7 0,000 3 0,000 1 MACRS-GOS ) WCRS-ADSIS) Headers & Footer OD Table Name 0 = 0 Investments are not included in Total Expenses for profit consideration, but are considered in the Cash Flow reductions CFAT- CEAT Cum Net Pratts CFAL-LP INW2 CFAT Cumu. CHAT NP-0. Disc LP.INV2 Net Pratit: Dis. CFA m ul Dix. CFAT Year Total Rey Total CFST Expenses IR-L) Test ment 70,000 Cash Flow 60,000 CFAL Loan Principal Interest Rate 10,000 0 Cumul Diu. Net Profits 0 1 2 Rate Amt 0 0 Net 2 Taxable Taxes Profits Inc PacTP) Ne 0 0 0 Table Font Size AA Amt 0 0 10,000 10,000 10,000 0 10000 10000 Table Outline OD 1 pto -30000 Outline table name OOO OOO 8 Grid Lines -100,000 Alternating Row Color Row & Column Size ? 125% Zoom T Insert . Chart I Text View Table Shape Media Comment Share Tips Format Document Text Body Update Update Amount Interest Start Year Loan Period Investment Life Depreciation Method Style Layout More Loan 1 Investment 1 Investment 2 MARR = 15% 60,000 70,000 30,000 Tax Rate = 25% MACRS-GDS MACRS-ADS-SL Font Trebuchet MS (Calibri) 11 pt Column Titles 1 Year 2 Total Revenues 3 Total Expenses 4 CFBT 5 Investment 6 Loan Cash Flow 7 CFAL 8 Loan Principal 9 Loan Interest 10 Depreciation Rate - Investment 1 11 Depreciation Amount - Investment 1 12 Depreciation Rate - Investment 2 13 Depreciation Amount - Investment 2 14. Taxable income 15. Taxes Paid(TP) 16. Net Profits(NP) 17. Cumulative Net Profits 18. CFAT - Method 1(CFAL - TP) 19. Cumulative CFAT-1 20. CFAT - Method Z(NP.Depreciation - Loan Principal - Investment (only for Investments after year 0) 21.Cumulative CFAT-2 (should be identical to Column 19) 22. Discounted Net Profits(NP) 23. Cumulative Discounted NP 24. Discounted CFAT 25. Cumulative Discounted CFAT B v Character Styles Character Style Alignment Show what checks from the totals you used to assure that you had the correct answers. The TEAM report cover page will include the names of the team members and the team name & number and be submitted electronically for grading and to all the team members. Designate who will send the team report. Individual reports must be submitted by each team member. E Spacing 1.0 - Single Bullets & Lists None 0 109% Zoom ul Chart T Text View Formula Table Shape Media Comment Share Tips Format Sort & Filter Sheet1 Table Cell Text Arrange G H I J K L M N O P Q R S T U V W X Matrta including: Revenues, Expenses, Investments CFDT, Loan Cash Flow, CFAL. Loan Principal, Loan Interest, Depreciatianicach investment). Taxable income Tases Paid, Net ProfitsiNP), Cumulative NP. CFAT, Cumulative CFAT, Discounted NP. Cumulative Discounted NP. Discounted CFAT, and Discountel CFAT Loan Interest Start Payment can life Sar! Date Der wechad Makitional Information Amt-$ Rate Date Start Y Table Styles 6 0 Loan Annual Payment PMP Amount 60,000 12201.5 $114.6657 Investment - 1 Investment- 2 Amount 7 0,000 3 0,000 1 MACRS-GOS ) WCRS-ADSIS) Headers & Footer OD Table Name 0 = 0 Investments are not included in Total Expenses for profit consideration, but are considered in the Cash Flow reductions CFAT- CEAT Cum Net Pratts CFAL-LP INW2 CFAT Cumu. CHAT NP-0. Disc LP.INV2 Net Pratit: Dis. CFA m ul Dix. CFAT Year Total Rey Total CFST Expenses IR-L) Test ment 70,000 Cash Flow 60,000 CFAL Loan Principal Interest Rate 10,000 0 Cumul Diu. Net Profits 0 1 2 Rate Amt 0 0 Net 2 Taxable Taxes Profits Inc PacTP) Ne 0 0 0 Table Font Size AA Amt 0 0 10,000 10,000 10,000 0 10000 10000 Table Outline OD 1 pto -30000 Outline table name OOO OOO 8 Grid Lines -100,000 Alternating Row Color Row & Column Size
