Engineering Economics help? (In 2007, Bell Mobility Inc., a publically owned

[hvern]

firm, considered a $5.74 million)? In 2007, Bell Mobility Inc., a publically owned firm, considered a $5.74 million order with Telefon AB LM Ericsson of Sweden for one of its existing networks. Make the following assumptions: the $5.74 million investment would have been completed in 2008. (All of the new assets belong to CCA class 46). In addition, Bell Mobility would pay for the order by obtaining a bank loan for 50% of the $5.74 million and using retained earnings for the remaining 50%. Bell Mobility can access loan money at a 5% interest rate. The new investment was projected to lead to 100,000 customers in 2008, with this number growing by 10,000 customers yearly. Average revenue per customer in 2008 was projected to be $43, which would grow to $48 in 2010 for the remainder of the project. Maintenance costs were expected to be $460,000 in 2008 and grow at 7% per year. Labour costs were estimated at $1.05 million per year, growing at the rate of 3 % per year. Overhead expenses were assumed to be 7.5% of the total investment cost in the first year of the project.

Fill in the following income statement to calculate Bell’s after-tax net income for each year under the assumption that the network will be retired at the end of 2012. Assume that Bell faced a provincial tax rate of 16% and a federal tax rate of 19%. [Hint: Bell's loan payments are of equal value each year; but, its interest payments and principle repayments will differ each year.
The following is a link to the table to fill out,

https://spreadsheets.google.com/ccc?key=0Ata3Ey1CZ_UpdE4wSmw4aldwaklzYTVtRVJWZ0dMWVE&hl=en

Thanks a lot, I really appreciate