In this mini-case you will help create documents related to the auditors report of the Apollo audit. Read and respond to all emails and requests from your manager. Complete all the steps on the audit program. Be sure to document your work using designated tick marks. When you are finished with each workpaper, enter your initials in the box in the top right marked "Prepared By". When you are finished with the entire workbook rename this document WrapUp_Firstname_Lastname and upload.

8 pages about Business Plan and Financial Analysis Workbook that on excel work .here is the date for the work that you need to make Business Plan and Financial Analysis Workbook. please make sure that you use easy english language because i'm not native english speaker.

03 Assignment - VLOOKUP and HLOOKUP VLOOKUP and HLOOKUP Continue working with the Employee Contact Information workbook you created last week for your boss. Now she needs a way to retrieve an employee's name by typing in an employee number. For example, if the employee’s name is ‘Sandy’ and her employee number is 1234, your boss wants to be able to find ‘Sandy’ by typing in 1234. Use the VLOOKUP or HLOOKUP functions to search the values in the columns or rows to retrieve the needed data. Pick an employee of your choice to demonstrate the lookup function. Follow these steps: In cell A8, type in one of the employee ID numbers that you entered into your contact list. Click in cell B8 and click the Insert Function button. Click the VLOOKUP function (NOTE: if you do not have it, type “vlookup” into the search box and click Go). Fill out the three arguments as described in the text: The lookup_value is the cell that has your ID number (click B8) The Table_array is the range – click and drag to select the table (note: do not include the column headers) The Column_index_num is the column in which you will find the Employee Name (type in the number 2) Click the OK button. Test by entering a different number in cell B8. Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates. Save your assignment as a Microsoft Excel workbook. (Mac users, please remember to append the ".xlsx" extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date.  03 Course Project - Analyzing with Functions Analyzing with Functions Functions are predefined formulas already available within Excel. By using them within a portfolio, Excel will do the needed financial calculations. Include the following functions within your project workbook. Use the SUM function to add the cost paid for each stock in your portfolio. Find the AVERAGE, MINIMUM, and MAXIMUM (using the appropriate functions) of: number of stocks purchased purchase price of each stock price paid for all stocks in your portfolio Perform a simple conditional analysis by using at least one logical function (i.e., IF, AND, OR...). Apply the test on only cells that contain data. For example, show whether the purchase price of one stock is higher or lower than the average purchase price of all stocks in your portfolio. In the column header to the right of your logical function, briefly explain the test being performed. Enter the function labels (SUM, AVERAGE, etc.) in the cells adjacent to the calculations so that a reader can easily tell what calculations are present in the worksheet.