In: Finance
You purchased a machine for $500,000 (installed), and you depreciated it using a 5 year MACRS. This machine generates $200,000 in annual revenue. In year 4, you sold the machine for $250,000. You received a loan for $400,000 on a 5 year loan at 5% (note, you must pay the remaining balance of this loan at the end of year 4 from the proceeds of the sale). In addition, you invested $80,000 in working capital initially. Your company is in a 35% tax bracket. MARR =15.36% Generate your cash flow analysis using Actual Dollars. In other words, inflate your revenue, salvage value, expenses and Working Capital accordingly. What is your Market NPW??inflation rate =3%?
The following are the data inputs in spreadsheet:
The following are the obtained results in spreadsheet: