Think_Big - C5:E5 End of Year 1 100 160 140 44.757...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Think-Big Development Co. Capital Budgeting Problem Office Shopping Building Hotel Center Range Name Cells Net Present Value 45 70 50 CapitalAvailable H9:H12 ($millions) Cumulative Cumulative CapitalRequired C9:E12 Capital Capital CapitalSpent F9:F12 Cumulative Capital Required ($millions) Spent Available ParticipationShare C16:E16 Now 40 80 90 25 <= 25 NetPresentValue
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: C5:E5 End of Year 1 100 160 140 44.757 &lt;= 45 TotalNPV H16 End of Year 2 190 240 160 60.583 &lt;= 65 End of Year 3 200 310 220 80 &lt;= 80 Office Shopping Total NPV Building Hotel Center ($millions) Participation Share 0.00% 16.50% 13.11% 18.11 A B C D E F G H I J K 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16...
View Full Document

Ask a homework question - tutors are online