I have some pre-calculus homework activities that I had spaced out over the semester, and they are due by tomorrow!

# Category: Mathematics

Please see the attached file “Extra Credit” for instructions.

Please also find the attached Syllabus and Lecture Notes that may be helpful for this assignment.

answer all 3 questions but for question 2 choose a

Sorry I meant to choose from a-d when you get to that part. This project has three parts to it

Make it clear what you are doing and why.

Edmond Halley (who discovered the famous comet) developed a root finding method that exhibits cubic conver-

gence. The method is derived at

http://mathworld.wolfram.com/HalleysMethod.html

and is written as (I uploaded the problem in the file)

I also need the analysis paper done along with the Ledger Account, Income Statement and Balance sheets tab to be completed.

Please refer to the instructions sheet in the attachments. Please select any topic under healthcare. THANK YOU!!!

Gemini, Inc., an all-equity firm, is considering a $1.7 million investment that will be depreciated according to the straight-line method over its four-year life. The project is expected to generate earnings before taxes and depreciation of $595,000 per year for four years. The investment will not change the risk level of the firm. The company can obtain a four-year, 9.5 percent loan to finance the project from a local bank. They will receive the total amount needed for investment ($1.7 million at time 0) and all principal will be repaid in one balloon payment at the end of the fourth year (similar to a bond). Every year the company would need to pay interest (@9.5%). If the company finances the project entirely with equity, the firm’s cost of capital would be 13 percent. The corporate tax rate is 30 percent. Calculate the cash flows and NPV for the two cases: a) If the company finances the project entirely with equity, and b) if the company finances the project entirely with the bank loan. Are the answers different? If so, why? Should the project be undertaken? (Hint: In the first case you need to discount your cash flows at 13% and in the second case with 9.5% when you calculate NPV).

Gemini, Inc., an all-equity firm, is considering a $1.7 million investment that will be depreciated according to the straight-line method over its four-year life. The project is expected to generate earnings before taxes and depreciation of $595,000 per year for four years. The investment will not change the risk level of the firm. The company can obtain a four-year, 9.5 percent loan to finance the project from a local bank. They will receive the total amount needed for investment ($1.7 million at time 0) and all principal will be repaid in one balloon payment at the end of the fourth year (similar to a bond). Every year the company would need to pay interest (@9.5%). If the company finances the project entirely with equity, the firm’s cost of capital would be 13 percent. The corporate tax rate is 30 percent. Calculate the cash flows and NPV for the two cases: a) If the company finances the project entirely with equity, and b) if the company finances the project entirely with the bank loan. Are the answers different? If so, why? Should the project be undertaken? (Hint: In the first case you need to discount your cash flows at 13% and in the second case with 9.5% when you calculate NPV).

Assignment Grading

This assignment counts for 12.5% of your final course grade. There is no grading rubric for this assignment. For each question you are required to show all of your work. This includes, as applicable: formulas, substitutions into the formulas with units, intermediate steps, and final answers with units.

Each of the assigned questions are worth the following amount of marks:

Chapter 13

Discussion Questions – Page 547

Q1 – 4 marks

Load-Distance Method – Page 547-548

Q1 – 6 marks (3 for a, 3 for b)

Q6 – 5 marks

Break-Even Analysis – Page 549

Q8 – 2 marks

Q10 – 4 marks (3 for a, 1 for b)

A Systematic Location Selection Process – Page 552

Q21 – 4 marks

Answers are attached for explanation.

Please have work done 24 hour a head of deadline, just to final check and approved if revise as needed. Might be a little lengthy, but will tip make up for the time spent.

Video will help with word document https://we.tl/t-qUxeD4H5bQ

Develop results tables for the outputs of your statistical tests and report the results of your hypothesis testing accordingly.

Step 1. Install

Install the Analysis ToolPak following the instructions:

Load the Analysis ToolPak in Excel – Microsoft

Links to an external site.

Step 2. Paste

Paste the values using the following instructions:

Data in the provided datasets are randomized and change automatically. Copy all of the cells on the sample dataset worksheet using they keyboard shortcuts [CTRL]+[A] and [CTRL]+[C] for Windows and [CMD]+[A] and [CMD]+[C], or using the right-click on your mouse.

Create a new worksheet in the Excel workbook.

Click on the Paste (clipboard) icon’s down arrow to show the menu. Choose “Paste Values.” This will ensure the values now remain static, so you can perform the statistical analysis on them.

Step 3. Run

Run Descriptive Statistics on the data. Click the Data toolbar and choose “Data Analysis” from the Analysis Ribbon.

Select “Descriptive Statistics.” Repeat the process for each variable. Note: You can only select numeric data for descriptive statistics. Do not select the column labels.

Step 4. Conduct

Conduct assumptions tests using the following instructions:

Create a histogram chart for each variable and each sample or group. Visually inspect the histogram for skewness or kurtosis. Do the data seem normally distributed for each variable? If not, the data are not normally distributed.

Conduct an F-Test to compare the populations for equal variances. Click the Data toolbar and choose “Data Analysis” from the Analysis Ribbon.

Select “F-Test Two-Sample for Variances.” Choose the ranges of the two samples and click “OK.” Is the F value greater than the F critical value? If so, the populations do not have equal variances.

Step 5. Conduct

If appropriate, conduct a correlational test using the following instructions:

With the dataset open in Microsoft Excel, select the “Data Analysis” button from the Data toolbar and Analysis ribbon. A dialog will appear showing a list of available statistical tests. Choose “Correlation.”

Another dialog will appear giving you options. For the Input Range, select the columns of the two variables you want to test for correlation. Data are grouped by Columns, so select that option.

Check “Labels in First Row” since we labeled our columns Clicks and Conversions.

Choose “New Worksheet” for “Output options” and click “OK.”

Insert a 2D line graph with two series (Column C and Column D) to represent the data.

Step 6. Conduct

If appropriate, conduct a t-test using the following instructions:

With the dataset open in Microsoft Excel, select the “Data Analysis” button from the Data toolbar and Analysis ribbon. A dialog will appear showing a list of available statistical tests. Choose “T-Test: Two-Sample” and base the selection on your assumptions testing (equal or unequal variances).

Select the ranges for each sample you are comparing for statistically significant difference.

Enter “0” for the hypothesized mean (H0: μ1 – μ2 = 0, (that is, there is no statistically significant difference between the means).

Select an output range, perhaps on a separate worksheet, and click “OK.”

Step 7. Conduct

If appropriate, conduct an ANOVA using the following instructions:

With the dataset open in Microsoft Excel, select “Data Analysis” button from the Data toolbar and Analysis ribbon. A dialog will appear showing a list of available statistical tests. Choose “Select Anova: Single Factor.”

Select all the samples or groups as your input range.

Select an output range, perhaps on a separate worksheet, and click “OK.”

Step 8. Submit

Save and submit the spreadsheet.