A 5 year project requires two investments of building extension and machinery. The building costs 300,000, and is depreciated at 20% diminishing value over 10 years. The machinery costs 1,000,000 and is depreciated over 5 years, and salvage value at the end of 5 years will be zero. working capital is accounted for at 10% of sales, which is 300,000 year, and is fully recovered at the end.
How do I include these in m y spreadsheet? A bit confused because the salvage value for machinery is zero, and the building is depreciated over 10 years. Also do I add working capital every year, or just the first year?