I am working on my finance project and am having trouble figuring out how to calculate the WACC . From there I have to calculate the NPV and IRR. I would like to complete this in excel but am unsure of where to start. I will attach the information I have to help with this. I have attached the balance sheet that we are suppose to use to get to these numbers. Can you guide me in the right direction on how to accomplish this please.

WACC and Capital Budgeting

• Calculate the firm's WACC (using 2018 numbers). (You will need to collect information on the long-term debt and common stock equity from the Balance Sheet. The firm has no preferred stock).
• Use the WACC to calculate NPV and evaluate IRR for proposed capital budgeting projects. Assume the projects are mutually exclusive and the firm has the money available to fund the project.

FIN300PortfolioProjectOption 1FinancialInformation (4) - Excel jamie schmieding X File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Share Cut Calibri 11 - A A = ab Wrap Text General Normal Bad AutoSum - AY O a Copy + Fill 41 4 Paste BIU - -LA- BE Merge & Center * % " Conditional Format as Good Neutral Insert Delete Format Sort & Find & Format Painter Formatting - Table Clear - Filter ~ Select - Clipboard Font Alignment Number Styles Cells Editing H15 X A B C D E F G H J K L M N O P Q R S T 12/31/2018 12/31/2017 12/31/2016 12/31/2015 2 Current Assets Cash And Cash Equivalents 8,719,000 10,607,000 9,157,000 9,095,000 Short Term Investments 270,000 8,897,000 6,966,000 2,912,000 Net Receivables 7,140,000 7,021,000 6,693,000 6,436,000 6 Inventory 3,126,000 2,944,000 2,722,000 2,719,000 Other Current Assets 2,042,000 43,000 31,000 730,000 Total Current Assets 21,297,000 29,512,000 25,569,000 21,892,000 10 Long Term Investments 2,407,000 2,039,000 1,949,000 2,310,000 11 Property Plant and Equipment 17,587,000 17,237,000 16,590,000 16,316,000 12 Goodwill 14,806,000 14,741,000 14,429,000 14,176,000 13 Intangible Assets 15,823,000 13,835,000 13,432,000 13,080,000 14 Other Assets 5,122,000 910,000 635,000 749,000 15 Total Assets 77,042,000 78,274,000 72,604,000 68,523,000 16 17 Current Liabilities 18 Accounts Payable 7,211,000 6,724,000 6,157,000 5,545,000 19 Short/Current Long Term Debt 3,951,000 4,017,000 4,400,000 3,108,000 20 Other Current Liabilities 6,601,000 4,112,000 3,870,000 3,882,000 21 Total Current Liabilities 17,763,000 14,853,000 14,427,000 12,535,000 LL 23 Long Term Debt 28,293,000 33,793,000 30,052,000 29,591,000 24 Other Liabilities 12,611,000 14,522,000 11,102,000 10,466,000 25 Total Liabilities 58,667,000 63,168,000 55,581,000 52,592,000 27 Stockholders Equity 28 Total Stockholder Equity 18,375,000 15,106,000 17,023,000 15,931,000 29 Balance Sheet Income Statement | Projects + + 100% ' )) 9:53 AM Search for anything O W X 11/21/2020