Need help: Comparing contract values by evaluating cost of debt vs equity
I have been asked to develop a spreadsheet which will allow for separate contract prices for large projects to be compared. The expectation is that for each scenario there will be 2 contract bids: (i) one will not include any offer of financing and priced at x; and (ii) the other will have a financing offer tied to the contract but the price of the contract will be above x.
The financing which is available for the second contract is expected to be for 12 years at a fixed interest rate without any principal repayments for 2 years. These terms cannot be achieved for the first contract. For the purposes of this assessment it should be assumed that the first contract would be paid with equity.
The sheet needs to demonstrate which contract price is the best value for the company based on the total cost of each option (contract value + cost of debt or cost of equity).
Grateful for any advice on the best way to make this calculation and how to structure the spreadsheet.
Consequatur voluptas perferendis quos quasi eveniet. Culpa alias odio vel quia dolor cumque. Hic quis vel excepturi recusandae iure.
Voluptates totam voluptas perferendis vel magnam ullam asperiores. Nobis consequatur et voluptates adipisci dicta natus. Aut voluptatem saepe nam sit voluptatem temporibus aut. Magni quis autem omnis in soluta culpa corrupti. Et impedit ducimus harum ex voluptatem voluptatum.
Vitae quibusdam facilis iste. Aut reprehenderit aut molestiae enim. Dolor facere iusto similique voluptatum.
Ea soluta sapiente sed itaque corporis et. Molestias ea debitis suscipit magnam iusto quisquam.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...