I need help filling in the information in the excel spreadsheets, please show the formulas in a excel spreadsheet, I attached to docs that contain notes in them about specific answers, additionally the initial question is below, leave a comment if you have any questions, thank you

1. Company Valuation

Your manager asked you to value Ted Enterprises, a potential acquisition. To make your life easier, your manager gave you some of the numbers in the Excel template file provided. Note that your manager wants the dollar price per share, so you must calculate the dollar value of the equity and then divide by the number of shares outstanding.