When using the free-cash flow model, cash flows are discounted at the weighted average cost of capital (WACC) and when using the dividend discount model, dividends are discounted at….
Fluid Mechanics – Excel sheet
Hardy Cross method for simple network – Excel)
Hardy Cross Method in Excel Part 1 (https://www.youtube.com/watch?v=pjUxSOCRVoo&feature=youtu.be)
Hardy Cross Method in Excel Part 2 (https://www.youtube.com/watch?v=t35MO1iMp4w&feature=youtu.be)
Hardy Cross Method in Excel Part 3 (https://www.youtube.com/watch?v=Tg4U3PdzzoY&feature=youtu.be)
Please watch these videos and create the same Excel worksheet as the example. To earn credits for this problem, you must submit this Excel file (format: .elsx). Wherever applicable, the correct equations must be used for the cells. Showing only the numbers without correct equations in the cells will not be acceptable.
• The empirical equations used in these videos are less common but acceptable for engineering designs.
Although different equations are used in the videos, the iterative approach is consistent with what we discussed in class. You will see how ∆???????? becomes negligible as the iteration continues
I need you to do the same thing in the videos, the same excel sheet in the videos (part 1,2, and 3)