looking for all the labled space
Sigma Company Cash Flows Sigma Company recently purchased a farm for $800,000. 2. The farm is expected to have a market value of $900,000 at EOY 3. 3. Revenues from operations are expected to be $600,000 at EOY 1 and to increase by $20,000 each year thereafter. 4. Operating and maintenance costs are expected to be $200,000 throughout the 3-year period of analysis. 5. Annual depreciation: DB method with a 10% rate. 6. The half-year rule applies. The before-tax with inflation interest rate is 10%. The before-tax inflation-free interest rate is 8%. The after-tax with inflation interest rate is 5%. 10. The after-tax inflation-free interest rate is 3%. 11. Inflation is 2% annually. 12. The tax rate = 50% 13. Sigma Company borrowed $500,000 at 10% which is to be repaid as follows: 10% at EOY 1; 40% at EOY 2: 50% at EOY 3. 7. 18. 9. Item EOYO EOY 1 AA EOY 2 EOY 3 1. BTCF (Actual $) BB 2. BTCF (Constant $) CC 3. Interest on Loan DD 4. Depreciation 5. Taxable income 6. Taxes Payable EE 7. ATCF (Actual $) 8. ATCF (Constant $) 9. Repayment of Loan FF 10. Interest on Loan 11. CFOE (Actual $) 12. CFOE (Constant $) GG Sigma Company Cash Flows Sigma Company recently purchased a farm for $800,000. 2. The farm is expected to have a market value of $900,000 at EOY 3. 3. Revenues from operations are expected to be $600,000 at EOY 1 and to increase by $20,000 each year thereafter. 4. Operating and maintenance costs are expected to be $200,000 throughout the 3-year period of analysis. 5. Annual depreciation: DB method with a 10% rate. 6. The half-year rule applies. The before-tax with inflation interest rate is 10%. The before-tax inflation-free interest rate is 8%. The after-tax with inflation interest rate is 5%. 10. The after-tax inflation-free interest rate is 3%. 11. Inflation is 2% annually. 12. The tax rate = 50% 13. Sigma Company borrowed $500,000 at 10% which is to be repaid as follows: 10% at EOY 1; 40% at EOY 2: 50% at EOY 3. 7. 18. 9. Item EOYO EOY 1 AA EOY 2 EOY 3 1. BTCF (Actual $) BB 2. BTCF (Constant $) CC 3. Interest on Loan DD 4. Depreciation 5. Taxable income 6. Taxes Payable EE 7. ATCF (Actual $) 8. ATCF (Constant $) 9. Repayment of Loan FF 10. Interest on Loan 11. CFOE (Actual $) 12. CFOE (Constant $) GG