Homework Answers
using Excel
| Years | Cash Flow | ||||
| Investment | utilities for path | Water utilities | Sponsorship | Net cash flow | |
| 0 | -291107.00 | -2,91,107 | |||
| 1 | -13323 | 129866 | 116543 | ||
| 2 | -13572 | 137658 | 124086 | ||
| 3 | -13821 | 145917 | 132096 | ||
| 4 | -14070 | 154672 | 140602 | ||
| 5 | -14319 | -14319 | |||
| 6 | -14568 | -14568 | |||
| 7 | -14817 | -14817 | |||
| 8 | -15066 | -15066 | |||
| 9 | -52269 | -15315 | -67584 | ||
| 10 | -212042 | -15564 | -24599 | -252205 | |
| 11 | -15813 | -27305 | -43118 | ||
| 12 | -16062 | -30308 | -46370 | ||
| 13 | -16311 | -33642 | -49953 | ||
| 14 | -16560 | -37343 | -53903 | ||
| 15 | -16809 | -41451 | -58260 | ||
| 16 | -17058 | -46010 | -63068 | ||
| 17 | -17307 | -51071 | -68378 | ||
| 18 | -17556 | -56689 | -74245 | ||
| 19 | -76752 | -17805 | -62925 | -157482 | |
| 20 | -18054 | -69847 | -87901 | ||
| 21 | -18303 | -77530 | -95833 | ||
| 22 | -18552 | -86058 | -104610 | ||
| 23 | -18801 | -95525 | -114326 | ||
| 24 | -19050 | -106033 | -125083 | ||
| 25 | -19299 | -117696 | -136995 | ||
| 26 | -19548 | -130643 | -150191 | ||
| 27 | -19797 | -145013 | -164810 | ||
| 28 | -20046 | -160965 | -181011 | ||
| 29 | -20295 | -178671 | -198966 | ||
| NPW | -6,31,856 | ||||
Showing formula in excel
| Years | Cash Flow | ||||
| Investment | utilities for path | Water utilities | Sponsorship | Net cash flow | |
| 0 | -291107 | =B3+C3+D3+E3 | |||
| 1 | -13323 | =129866 | =B4+C4+D4+E4 | ||
| 2 | =C4-249 | =E4*1.06 | =B5+C5+D5+E5 | ||
| 3 | =C5-249 | =E5*1.06 | =B6+C6+D6+E6 | ||
| 4 | =C6-249 | =E6*1.06 | =B7+C7+D7+E7 | ||
| 5 | =C7-249 | =B8+C8+D8+E8 | |||
| 6 | =C8-249 | =B9+C9+D9+E9 | |||
| 7 | =C9-249 | =B10+C10+D10+E10 | |||
| 8 | =C10-249 | =B11+C11+D11+E11 | |||
| 9 | -52269 | =C11-249 | =B12+C12+D12+E12 | ||
| 10 | -212042 | =C12-249 | -24599 | =B13+C13+D13+E13 | |
| 11 | =C13-249 | =D13*1.11 | =B14+C14+D14+E14 | ||
| 12 | =C14-249 | =D14*1.11 | =B15+C15+D15+E15 | ||
| 13 | =C15-249 | =D15*1.11 | =B16+C16+D16+E16 | ||
| 14 | =C16-249 | =D16*1.11 | =B17+C17+D17+E17 | ||
| 15 | =C17-249 | =D17*1.11 | =B18+C18+D18+E18 | ||
| 16 | =C18-249 | =D18*1.11 | =B19+C19+D19+E19 | ||
| 17 | =C19-249 | =D19*1.11 | =B20+C20+D20+E20 | ||
| 18 | =C20-249 | =D20*1.11 | =B21+C21+D21+E21 | ||
| 19 | -76752 | =C21-249 | =D21*1.11 | =B22+C22+D22+E22 | |
| 20 | =C22-249 | =D22*1.11 | =B23+C23+D23+E23 | ||
| 21 | =C23-249 | =D23*1.11 | =B24+C24+D24+E24 | ||
| 22 | =C24-249 | =D24*1.11 | =B25+C25+D25+E25 | ||
| 23 | =C25-249 | =D25*1.11 | =B26+C26+D26+E26 | ||
| 24 | =C26-249 | =D26*1.11 | =B27+C27+D27+E27 | ||
| 25 | =C27-249 | =D27*1.11 | =B28+C28+D28+E28 | ||
| 26 | =C28-249 | =D28*1.11 | =B29+C29+D29+E29 | ||
| 27 | =C29-249 | =D29*1.11 | =B30+C30+D30+E30 | ||
| 28 | =C30-249 | =D30*1.11 | =B31+C31+D31+E31 | ||
| 29 | =C31-249 | =D31*1.11 | =B32+C32+D32+E32 | ||
| NPW | =NPV(6%,F4:F32)+F3 | ||||
Add Answer to:
The city of Waterbourne has made it a strategic goal to enhance livability in the city....
The city of Waterbourne has made it a strategic goal to enhance livability in the city. The city has decided to undertak...
The city of Waterbourne has made it a strategic goal to enhance livability in the city. The city has decided to undertake a project that will occur in two phases. During the first phase, the city will connect several of the parks with walking paths. During the second phase, the city will add water features or splash fountains to several of the parks. The initial cost of the project will be $381,944. Annual utilities for maintaining the walking paths and...
Swanson Brothers, Inc. is putting together a bid for a multi-year state project. The project will have a lifespan of 12...
Swanson Brothers, Inc. is putting together a bid for a multi-year state project. The project will have a lifespan of 12 years. If successful, the state will pay Swanson $131,078 at the end of each year, increasing the payment by $28,943 each subsequent year. The project will have expenses of $46,352 per year. Part way through the project, Swanson will need to rent some special equipment at a cost of $2,985 per year, with the cost decreasing by 10% each...
Swanson Brothers, Inc. is putting together a bid for a multi-year state project. The project will have a lifespan of 10...
Swanson Brothers, Inc. is putting together a bid for a multi-year state project. The project will have a lifespan of 10 years. If successful, the state will pay Swanson $135,051 at the end of each year, increasing the payment by $33,708 each subsequent year. The project will have expenses of $42,529 per year. Part way through the project, Swanson will need to rent some special equipment at a cost of $3,801 per year, with the cost decreasing by 9% each...
Swanson Brothers, Inc. is putting together a bid for a multi-year state project. The project will have a lifespan of 10...
Swanson Brothers, Inc. is putting together a bid for a multi-year state project. The project will have a lifespan of 10 years. If successful, the state will pay Swanson $116,193 at the end of each year, increasing the payment by $31,646 each subsequent year. The project will have expenses of $49,293 per year. Part way through the project, Swanson will need to rent some special equipment at a cost of $3,112 per year, with the cost decreasing by 8% each...
Swanson Brothers, Inc. is putting together a bid for a multi-year state project. The project will...
Swanson Brothers, Inc. is putting together a bid for a multi-year state project. The project will have a lifespan of 12 years. If successful, the state will pay Swanson $147,656 at the end of each year, increasing the payment by $34,885 each subsequent year. The project will have expenses of $47,147 per year. Part way through the project, Swanson will need to rent some special equipment at a cost of $3,373 per year, with the cost decreasing by 8% each...
Swanson Brothers, Inc. is putting together a bid for a multi-year state project. The project will...
Swanson Brothers, Inc. is putting together a bid for a multi-year state project. The project will have a lifespan of 10 years. If successful, the state will pay Swanson $129,868 at the end of each year, increasing the payment by $31.525 each subsequent year. The project will have expenses of $48,172 per year. Part way through the project, Swanson will need to rent some special equipment at a cost of $3,937 per year, with the cost decreasing by 8% each...
Prepare journal entries for each of the following transactions entered into by the City of Loveland....
Prepare journal entries for each of the following transactions entered into by the City of Loveland. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) Fund/ Governmental Transaction Activlies General Journal Debit Credit 1. The city received a donation of land that is to be used by Parks and Recreation to develop a public park. At the time of the donation, the land had an acquisition value of $5.200,000 and was...
Prepare journal entries for each of the following transactions entered into by the City of Loveland....
Prepare journal entries for each of the following transactions
entered into by the City of Loveland. (If no entry is
required for a transaction/event, select "No Journal Entry
Required" in the first account field.)
Transaction Fund / Governmental Activties General Journal Debit Credit 1. The city received a donation of land that is to be used by Parks and Recreation to develop a public park. At the time of the donation, the land had an acquisition value of $5,200,000 and...
Prepare journal entries for each of the following transactions entered into by the City of Loveland....
Prepare journal entries for each of the following transactions entered into by the City of Loveland. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) Transaction Fund / Governmental Activties General Journal Debit Credit 1. The city received a donation of land that is to be used by Parks and Recreation to develop a public park. At the time of the donation, the land had an acquisition value of $5,200,000 and...
A major city in Eastern Canada is planning to build a new wastewater treatment plant to...
A major city in Eastern Canada is planning to build a new wastewater treatment plant to accommodate the increasing water consumption of the city, Plant construction will start in 2018 and is going to take five years at a cost of $30 million per year. After construction is completed, the cost of operation, maintenance is expected to be $2 million for the first year, and to increase by 1% per year thereafter. The salvage/scrap value of the wastewater treatment plant...
Swanson Brothers, Inc. is putting together a bid for a multi-year state project. The project will have a lifespan of 12 years. If successful, the state will pay Swanson $147,656 at the end of each year, increasing the payment by $34,885 each subsequent year. The project will have expenses of $47,147 per year. Part way through the project, Swanson will need to rent some special equipment at a cost of $3,373 per year, with the cost decreasing by 8% each...
Swanson Brothers, Inc. is putting together a bid for a multi-year state project. The project will have a lifespan of 10 years. If successful, the state will pay Swanson $129,868 at the end of each year, increasing the payment by $31.525 each subsequent year. The project will have expenses of $48,172 per year. Part way through the project, Swanson will need to rent some special equipment at a cost of $3,937 per year, with the cost decreasing by 8% each...
Prepare journal entries for each of the following transactions entered into by the City of Loveland. (If no entry is required for a transaction/event, select "No Journal Entry Required" in the first account field.) Fund/ Governmental Transaction Activlies General Journal Debit Credit 1. The city received a donation of land that is to be used by Parks and Recreation to develop a public park. At the time of the donation, the land had an acquisition value of $5.200,000 and was...
Prepare journal entries for each of the following transactions
entered into by the City of Loveland. (If no entry is
required for a transaction/event, select "No Journal Entry
Required" in the first account field.)
Transaction Fund / Governmental Activties General Journal Debit Credit 1. The city received a donation of land that is to be used by Parks and Recreation to develop a public park. At the time of the donation, the land had an acquisition value of $5,200,000 and...
A major city in Eastern Canada is planning to build a new wastewater treatment plant to accommodate the increasing water consumption of the city, Plant construction will start in 2018 and is going to take five years at a cost of $30 million per year. After construction is completed, the cost of operation, maintenance is expected to be $2 million for the first year, and to increase by 1% per year thereafter. The salvage/scrap value of the wastewater treatment plant...
Most questions answered within 3 hours.
-
Convert the high level language programming statementts to 80x86
assembly, Assume X=AX and y=BX
for (i=1;...
asked 5 minutes ago -
SoleMate’s Burkins sneakers cost $40 per pair from the supplier
and are sold by SoleMate at...
asked 10 minutes ago -
The movie Moneyball (based on the book by Michael
Lewis) tells the story of Billy Beane,...
asked 9 minutes ago -
A regional highway uses 8 tollbooths that are open to all
vehicles. A chi-square goodness-of-fit test...
asked 12 minutes ago -
In her Semiannual Monetary Policy Report to Congress on July 13,
2017, then Federal Reserve Chair...
asked 11 minutes ago -
Suppose N packets are sent,
and each packet arrives at rate of L/2R to a link....
asked 30 minutes ago -
17. Show the steps involved in reduction of the ketone in fatty
acid synthesis. Which cofactor...
asked 32 minutes ago -
5.61 g of octane, C8H18, reacts with excess oxygen in a bomb
calorimeter. The heat capacity...
asked 36 minutes ago -
The velocity field of a flow is given by V = (2+1) x
y2 i +...
asked 45 minutes ago -
(EPS with
Convertible Bonds) On June 1, 2012, Bluhm Company and
Amanar Company merged to form...
asked 42 minutes ago -
2. Discuss why the study exemplifies one that agrees with The
American Psychological Association’s (APA) Ethical...
asked 46 minutes ago -
Without considering the following capital gains and losses,
Charlene, who is single, has a taxable income...
asked 53 minutes ago