FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 6 1. Retrieve the file HWChapter6 and solve Problem 6-12 using the organizational design displayed in the worksheet file. Do not modify the fonts, format, or cell addresses 2. Problem 6-12. Enter equations that solve for the values required in Cells C95, C96, D114, F114, D123, F123, E129, E136, E139, E144, E151, E152, E154, E155, E156. 9, Print the worksheet 87 88 Problem 6-12 89 90 Part a 91 92 Net operating profit after taxes (NOPAT), Year 2 = EBIT(1-T) 93 94 95 96 97 98 Part b. EBIT T (40%) NOPAT $1,260 100 Operating current assets = Total current assets-short-term investments 101 Operating current liabilities Total current liabilities - notes payable 102 Net operating working capital (NOWC) - Operating current assets - operating 103 104 105 106 Total current assets 107 Short-term investments 108 Operating current assets 109 110 Total current liabilities 111 Notes payable 112 Operating current liabilities 113 114 NOWC 115 116 Part c. current liabilities Year 2 Year 1 $5,060 110 $4,950 $4,600 100 $4,500 $2,034 $384 S1,650 $1,700 200 $1,500 118 Total net operating capital- NOWC + Net plant and equipment 119 120 121 NOWC 122 Net plant and equipment 123 Total net operating capital 124 125 126 127 128 129 130 Year 2 Year 1 S0 3,850 S3,850 S0 S3,500 Summa ANOWO ANet plant and equipment ATotal net operating capital ry (previews Part d) $350 -Net investment in operating capital FIN3310: INTERMEDIATE FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Chapter 6 1. Retrieve the file HWChapter6 and solve Problem 6-12 using the organizational design displayed in the worksheet file. Do not modify the fonts, format, or cell addresses 2. Problem 6-12. Enter equations that solve for the values required in Cells C95, C96, D114, F114, D123, F123, E129, E136, E139, E144, E151, E152, E154, E155, E156. 9, Print the worksheet 87 88 Problem 6-12 89 90 Part a 91 92 Net operating profit after taxes (NOPAT), Year 2 = EBIT(1-T) 93 94 95 96 97 98 Part b. EBIT T (40%) NOPAT $1,260 100 Operating current assets = Total current assets-short-term investments 101 Operating current liabilities Total current liabilities - notes payable 102 Net operating working capital (NOWC) - Operating current assets - operating 103 104 105 106 Total current assets 107 Short-term investments 108 Operating current assets 109 110 Total current liabilities 111 Notes payable 112 Operating current liabilities 113 114 NOWC 115 116 Part c. current liabilities Year 2 Year 1 $5,060 110 $4,950 $4,600 100 $4,500 $2,034 $384 S1,650 $1,700 200 $1,500 118 Total net operating capital- NOWC + Net plant and equipment 119 120 121 NOWC 122 Net plant and equipment 123 Total net operating capital 124 125 126 127 128 129 130 Year 2 Year 1 S0 3,850 S3,850 S0 S3,500 Summa ANOWO ANet plant and equipment ATotal net operating capital ry (previews Part d) $350 -Net investment in operating capital