Spreadsheet template: The Poughkeepsie Development Corporation (PDC) is trying to complete its investment plans for the next
Fantastic news! We've Found the answer you've been seeking!
Question:
Spreadsheet template:
Transcribed Image Text:
The Poughkeepsie Development Corporation (PDC) is trying to complete its investment plans for the next five years. Currently PDC has $4.9 million available for investment. Furthermore, PDC expects income streams from other business ventures over the next 4 years of $3.8 million, $2.6 million, $3.6 million, and then $3.0 million. These data are summarized in the table below. (For simplicity of modeling, you may assume that these income streams occur at one year intervals.) Cash Available for Investment ($millions) Now 4.90 One Year from Now 3.80 Two Years from Now 2.60 3.60 3.00 Three Years from Now Four Years from Now There are three development projects that PDC is considering. The first is the Poughkeepsie Vacation Resort on the picturesque banks of the Hudson River. A second project, the Hudson River Mall, would be a shopping complex adjacent to the Poughkeepsie Vacation Resort. The third project, the Poughkeepsie Office Building (or POB), is a 6- story office building to be built in downtown Poughkeepsie starting in two years, after the demolition of several smaller buildings. If PDC participates fully in these projects, each would have the projected cash flow streams over the next four years as indicated in the following table. (Again, for simplicity, you may assume these cash flows occur at one year intervals.) The estimated value of each project five years from now is also indicated. Cash Flow ($millions) Now One Year from Now Two Years from Now Three Years from Now Four Years from Now Value Five Years from Now ($millions) Vacation Resort -6.00 -4.40 3.60 3.00 3.20 14.00 Hudson River Mall -5.80 -2.80 2.20 2.80 3.20 13.00 Office (POB) 0.00 -0.10 -2.50 -1.80 -2.20 15.00 The Poughkeepsie Development Corporation (PDC) is trying to complete its investment plans for the next five years. Currently PDC has $4.9 million available for investment. Furthermore, PDC expects income streams from other business ventures over the next 4 years of $3.8 million, $2.6 million, $3.6 million, and then $3.0 million. These data are summarized in the table below. (For simplicity of modeling, you may assume that these income streams occur at one year intervals.) Cash Available for Investment ($millions) Now 4.90 One Year from Now 3.80 Two Years from Now 2.60 3.60 3.00 Three Years from Now Four Years from Now There are three development projects that PDC is considering. The first is the Poughkeepsie Vacation Resort on the picturesque banks of the Hudson River. A second project, the Hudson River Mall, would be a shopping complex adjacent to the Poughkeepsie Vacation Resort. The third project, the Poughkeepsie Office Building (or POB), is a 6- story office building to be built in downtown Poughkeepsie starting in two years, after the demolition of several smaller buildings. If PDC participates fully in these projects, each would have the projected cash flow streams over the next four years as indicated in the following table. (Again, for simplicity, you may assume these cash flows occur at one year intervals.) The estimated value of each project five years from now is also indicated. Cash Flow ($millions) Now One Year from Now Two Years from Now Three Years from Now Four Years from Now Value Five Years from Now ($millions) Vacation Resort -6.00 -4.40 3.60 3.00 3.20 14.00 Hudson River Mall -5.80 -2.80 2.20 2.80 3.20 13.00 Office (POB) 0.00 -0.10 -2.50 -1.80 -2.20 15.00
Expert Answer:
Related Book For
Financial Management for Decision Makers
ISBN: 978-0138011604
2nd Canadian edition
Authors: Peter Atrill, Paul Hurley
Posted Date:
Students also viewed these accounting questions
-
Revise the Excel spreadsheet in Figure 8.1 to create a template for a decision with four alternatives and four outcomes. Figure 8.1 IF function is used to identify the best alternative. Identifies...
-
Revise the Excel spreadsheet in Figure 8.3 to create a template for a decision with four alternatives and four outcomes. Figure 8.3 A. D. E 1 Thompson Lumber (Dec Making Under Risk) 3 PAYOFFS...
-
Using the spreadsheet template provided, calculate the value of Generic Research under the growth strategy. In addition to the growth rate: They will spend an extra $5M on advertising in 2013, 2014...
-
On January 1, 2018, Doctors Credit Union (DCU) issued 7%, 20-year bonds payable with face value of $200,000. The bonds pay interest on June 30 and December 31. Requirements 1. If the market interest...
-
Construct a game-theory matrix involving two firms and their decisions on high versus low advertising budgets and the effects of each on profits. Show a circumstance in which both firms select high...
-
The following accounts are from Mizuko Limited's general ledger. All data are shown before tax. Sales revenue ...................................................... $306,000 Interest revenue...
-
The accounts of for the year ended March 31,2010, for Clark Industries, Inc. are listed next: Requirements 1. Prepare Clark Industries multi-step income statement. 2. Prepare Clark Industries...
-
Rank the following securities from lowest (1) to highest (8) in terms of their riskiness for an investor. All securities (except the Treasury bond) are for a given firm. If you think two or more...
-
What is Sally's gross annual retirement income need (from all income sources) in TODAY's dollars at the beginning of her first year in retirement? What is Sally's net annual retirement income need...
-
The Metropolis Health Systems Rehabilitation and Wellness Center offers outpatient therapy and return-to-work services plus cardiac and pulmonary rehabilitation to get people back to a normal way of...
-
Answer the following questions using the SQL (Structured Query Languages): a. write query in SQL to create Employees table using Table-1. b. write query in SQL to find the highest salary employees c....
-
LGP produces computer hardware equipment. The following information was collected for the latest month: Actual market size (units) 32,000 Budgeted market size (units) 20,000 Actual market share 40%...
-
Make Versus Buy: Samaneh's SKateboard Company produces high quality skateboards at affordable prices with over 10 different types of skateboards. Most of the manufacturing occurs in Hawaii. The top...
-
Sandhill Corporation is in the process of setting a selling price for a recently designed product. The following data relate to this product at a budgeted volume of 60,000 units. Direct materials...
-
We want to find the root of the following function using fixed-point iteration: f(x)=2-2ln(x) - x a) Finding the root of an equation can be difficult because the algorithm may diverge or go to a...
-
Find the slope of the line through the points (-3, 7) and (-9,2). Enter your answer as a simplified improper fraction, if necessary. Do not include "m="in your answer.
-
Explain how a shareholder can, without knowing the future, diversify away the unsystematic risk of your company's stock potentially suffering a return that unexpectedly turns out to equal the...
-
What are the typical record-at-a-time operations for accessing a file? Which of these depend on the current file record?
-
You have gathered data from the annual reports of the following companies: Required: (a) Calculate EVA for each company. (b) In which company would you buy shares? Why? Moose Ltd Gateau Inc Ski Corp...
-
Threads Limited manufactures nuts and bolts, which are sold to industrial users. The abbreviated financial statements for 2010 and 2009 are as follows. Required: (a) Assuming that all sales and...
-
Some businesses operate on a low operating profit margin (for example, a supermarket chain). Does this mean that the return on capital employed from the business will also be low?
-
Determine the greatest magnitude of the applied forces P if the allowable bending stress is ( c ) allow = 50 MPa in compression and ( t ) allow =120 MPa in tension. 250 mm 75 mm 10 mm 10 mm- 150 mm...
-
If P = 6kN, determine the maximum tensile and compressive bending stresses in the beam. 250 mm 75 mm 10 mm 10 mm- 150 mm 160 mm 10 mm P 150 mm
-
The bar is subjected to a moment M = 40 Nm of Determine the smallest radius r of the fillets so that an allowable bending stress of allow = 124MPa is not exceeded. M 20 mm 80 mm 7 mm M
Study smarter with the SolutionInn App