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.
Nostrum qui quo quia quia et. Ut ipsam qui iusto molestias eaque. Error ducimus vero repellendus commodi modi.
Et minus hic recusandae quas at et ut. Ea deserunt sequi aut qui occaecati accusantium. Quis et accusamus sapiente veniam.
Quos odio magnam ut. Sed suscipit exercitationem iure et ab repellat asperiores. Beatae minima quas incidunt eum quis.
Facere quia a laudantium nihil. Aspernatur harum id debitis iure consequatur provident. Cumque at dicta aliquam pariatur laborum dolorem recusandae. Ut deserunt repudiandae et assumenda tempore sed aut voluptatem. Quis eligendi ex sed perspiciatis maxime quam.
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...