Do the following problems in Excel. Submit your Excel spreadsheet so I can see how you solved the problems (functions you used).

1. Assume the same facts as in part 1, except on Feb. 1, 2016, due to financial problems, Barrick deposit nothing in the fund. After this date, they resume and make sufficient equal payments to meet their goal of $32 million on Aug. 1, 2018. In other words, they make the same amount of payments in the fund as part 1 from Aug. 1, 2013-Aug. 1, 2018. Determine the first set of required payments and the second set of required payments. (10 points).

2. Barrick is comparing two gold mines.

Mine A: The mine is expected to make $3.5 billion in year 1, $4.5 billion in year 2, and $5.5 billion in years 3-6 and $4.25 billion in years 7-10. At the end of year 10, Barrick will need to spend $202 million on environmental clean-up costs and expects the residual value to be $200 billion.

Mine B: The mine is currently in operation and produces $4.1 billion per year. At the end of 10 years the residual value would be $200 billion and no environmental clean-up costs would be necessary.

Which mine should Barrick buy for $142 billion. (To simplify things, assume Net Income is earned one time per year at the end of the year.) The appropriate discount rate is 6.22% compounded quarterly. (15 points)

(For C++) Assume that sentence is a variable of type  string  that has been assigned a value . Assume furthermore that this value is a string consisting of words separated by single space characters with a period at the end. For example: "This is a possible value of sentence."

Assume that there is another variable  declared , secondWord, also of type  string . Write the statements needed so that the second word of the value of sentence is assigned to secondWord. So, if the value of sentence were "Broccoli is delicious." your code would assign the value "is" to secondWord.

List the relational operators recognized by Python, and explain their meanings

Sports Corp has 11.8 million shares of common stock outstanding, 6.8 million shares of preferred stock outstanding, and 2.8 million bonds. If the common shares are selling for $26.8 per share, the preferred shares are selling for $14.3 per share, and the bonds are selling for 96.82 percent of par, what would be the weight used for equity in the computation of Sports's WACC? 55.14% 10.12% 33.33% 11.26%

Par Value 1000

 How does variety lead to paralysis of action?

Consider a market consisting of several small pulp & paper mills operating in the South-east. These firms discharge chlorine and other waste products into nearby rivers and streams. The rivers and streams are not privately owned, and the mills’ discharges are currently unregulated by the EPA or by the states’ environmental agencies. The demand for paper produced by the mills in this market is P = 800 - 0.5Q. The marginal cost of producing paper in this market is MC = 20 + 0.3Q, where P and MC are expressed in dollars, and Q is expressed in tons of pulp and paper.

a. Determine this market’s equilibrium price and quantity, total revenue, marginal cost, consumer and producer surplus.

b. University researchers estimate that chlorine emissions from the industry's production impose costs, unaccounted for the industry or the market in which it operates, equal to P = 0.05Q. Determine the market’s efficient equilibrium price and quantity when all costs are accounted for.

c. The researchers then suggest that a tax, equal to the unaccounted for costs, be imposed on the production of pulp & paper in this market. What is the dollar amount of the tax? How much in revenue would the government collect? Would the market be inefficient with the tax? Explain (briefly and concisely) your answer.

What are the common types of social media? How do they differ from each other?

Explain Business Intelligence in one page or less. Focus upon the concept that ‘BI’ is an umbrella term and explain what the components of a ‘BI’ system are and what its architecture and purpose are.

Given the following list of values, perform a binary search for the indicated search item. Use the binary search algorithm on pg. 1026 of our textbook. Show the values of first, last and middle, and the number of comparisons made after each iteration of the loop. Your should create a table like the following to show your work, where first and last are the values of the variables at the beginning of the loop, and mid is the midpoint used during that iteration, list[mid] is the value in the list at the midpoint, and No. of key comparisons should be the number of comparisons made during this iteration by the algorithm:

Iteration  first   last    mid  list[mid]   No. of key comparisons
1          0       12      ?    ?           ?

List:
[ 2, 3, 4, 4, 5, 7, 10, 14, 15, 17, 22, 23, 24 ]

Searching for value: 3

Language: Python

Create a graph and then set initial and goal states such that the number of nodes visited for BFS is smaller than that in DFS. Now modify the initial and goal state such that the number of nodes visited for BFS is larger than that in DFS.

If 4.1 g of butanoic acid, C4H8O2, is dissolved in enough water to make 1.0 L of solution, what is the resulting pH?

Is population growth an impediment for economic development? Discuss the arguments in favour and against.

A private opinion poll is conducted for a politician to determine what proportion of the population favors decriminalizing marijuana possession. How large a sample is needed in order to be 95% confident that the sample proportion will not differ from the true proportion by more than 2%?

A. 2401

B. 25

C. 1692

D. 4802

Magnetism

What types of poles are there and how do they interact?

Explain three situations in which a magnetic force will interact. (hint: two poles, current carrying wire, moving

charge)

What affects the induced current of a coil in a magnetic field?

Marin Construction Company began work on a $424,000 construction contract in 2020. During 2020, Marin incurred costs of $279,500, billed its customer for $204,500, and collected $170,500. At December 31, 2020, the estimated additional costs to complete the project total $150,500. Prepare Marin’s journal entry to record profit or loss, if any, using (a) the percentage-of-completion method and (b) the completed-contract method. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No entry" for the account titles and enter 0 for the amounts. Round answers to 0 decimal places, e.g. 5,275.)