Multiple Problems

For Help with Multiple Homework Problems, Ask an Expert

Multiple Problems

# The CEO has decided to plan for a salary action affecting a

number of individuals in the...
The CEO has decided to plan for a salary action affecting a number of individuals in the organization. He has decided to give a \$2,000 cost-of-living pay increase to all hourly employees and a \$4,000 increase to all software analysts with salaries less than \$55,000. However, he wants to do this in 2 years. He wants you to give him two options (you do not have to recommend an option).

Option 1: How much would he have to invest today in a single lump sum at a 6% annual interest rate compounded quarterly to have sufficient funds to execute his plan?

Option 2: How much would he have to invest in equal monthly payments at a 3% annual interest rate compounded monthly to have sufficient funds to execute his plan?

Because the CEO wants to increase salaries for all hourly employees and software analysts, there needs to be a count of the employees in each category.
1.Create an additional worksheet named “DB Calculations.”
2.Set up a criteria range in the first few rows and columns to identify all hourly employees. Use this criteria in the Advanced Filter feature to extract all hourly employees.
3.Set up a second criteria range in the columns next to the first to identify the software analysts with salaries less than \$55,000. Use this criteria in the Advanced Filter feature to extract all hourly employees.
4.In any cell beneath each criteria range, use the DCOUNT function to calculate the number of hourly employees using the first criteria range, and then again to calculate the number of software analysts with salaries less than \$55,000.
5.Multiply the count of hourly employees by 2,000, and the count of software analysts with salaries less than \$55,000 by 4,000. The sum of these two numbers will be the total funding needed to execute the CEO’s plan.

Part 2: Use the funding you calculated in Part 1 and the appropriate compound interest formulas you learned in business algebra to calculate the investment amounts for options 1 and 2. Show your calculations in any empty area on the worksheet created in Part 1.

Hints:

Excel Functions:

PV – Returns the present value of a future amount

PMT – Calculates the payment necessary to accumulate a future amount

Compound Interest Formulas:

A = P(1 + i)n

FV = PMT × (1 + i)n – 1

--------------------------------------------------------------------------------

i

Part 3: Add at least 1 paragraph to the memo from Week 4 showing the comparison between the two investment options
Show More
Show Less
8/13/2013
Category: Multiple Problems
Satisfied Customers: 5
Verified
Hello,

I'm Josie and I'm a moderator for this topic.

We have been working with our professionals to try to help you with your question. Sometimes it may take a bit of time to find the right fit.

I was checking to see if you had already found your answer or if you still need assistance from one of our professionals.

Please let me know if you wish to continue waiting or if you would like for us to close your question?

Thank you,

Josie~Moderator
Customer reply replied 4 years ago
Hello Josie. I still need help with my question.
Hello

Thank you, XXXXX XXXXX continue to look for a professional to assist you. Please let me know if I can be of any further assistance while you wait.

Best,
Josie~Moderator
Mr. Gregory White, Master's Degree
Category: Multiple Problems
Satisfied Customers: 5,240
Experience: M.A., M.S. Education / Educational Administration
Verified

Feel free to request me anytime. Just put "For TeacherGreg" at the front of your post or, even better, bookmark my weblink at www.GregPearl.com and use the question box on my page - still put the "For TeacherGreg" in the front of the post so it is directly sent to me.

All the best in your studies and have a wonderful rest of the week.
Mr. Gregory White, Master's Degree
Category: Multiple Problems
Satisfied Customers: 5,240
Experience: M.A., M.S. Education / Educational Administration
Verified
Mr. Gregory White, Master's Degree
Category: Multiple Problems
Satisfied Customers: 5,240
5,240 Satisfied Customers
Experience: M.A., M.S. Education / Educational Administration

Mr. Gregory White is online now

A new question is answered every 9 seconds

• Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
• Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

## What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

## Meet the Experts:

linda_us

Master's Degree

1,402 satisfied customers

A tutor for Business, Finance, Accounts and other related topics.

F. Naz

B.Com

1,078 satisfied customers

have completed B.Com and CA Finalist

Manal Elkhoshkhany

Bachelor's Degree

909 satisfied customers

Completed by BA degree in 1988 and graduated with a GPA of 4.0

Mr. Gregory White

Master's Degree

5,240 satisfied customers

M.A., M.S. Education / Educational Administration

Bizhelp

CPA

539 satisfied customers

BA degree and Certified Public Accountant

MyVirtualCPA

Master's Degree

155 satisfied customers

Dimitry K., Esq.

Doctoral Degree

39 satisfied customers

< Previous | Next >

Related Multiple Problems Questions
1.) Prepare and analyze a statement of cash flows for the
1.) Prepare and analyze a statement of cash flows for the company for all 3 years of available data. 2.) Prepare and analyze common size balance sheet and income statements. 3.) Compute and analyze a … read more
Manal Elkhoshkhany
Bachelor's Degree
909 satisfied customers
Rosie has owned a successful luncheonette for several years.
Rosie has owned a successful luncheonette for several years. Tired of the long hours and eager to try another way of life, she decides to buy a fishing boat and start a charter service near Key West. … read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
Randall Corporation acquired 80 percent of Sharp's voting
Randall Corporation acquired 80 percent of Sharp's voting shares on January 1, 2014, for \$280,000 in cash. At that date, the noncontrolling interest had a fair value of \$70,000 and Sharp reported net … read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
1. NCC Corporation is considering building a new facility in
1. NCC Corporation is considering building a new facility in Texas. To raise money for the capital projects, the corporation plans the following capital structure: 30% of money will come from issuing … read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
When an asset is disposed of, there are several questions
When an asset is disposed of, there are several questions the tax accountant must answer in determining the tax implications of the disposition. These include the type of asset, the amount realized, t… read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
During 2018, they have the following transactions related to
During 2018, they have the following transactions related to the assets: a. In June, an electrical connection shorts out and starts a fire in Emelio's building. The cost of repairing the damage caused… read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
A. Dividends Per Share: Maurice, Inc. has stock issued as
A. Dividends Per Share: Maurice, Inc. has stock issued as follows: 20,000 shares of cumulative 4% preferred stock \$100 par and 100,000 shares of \$50 par common. During its first five years of operatio… read more
F. Naz
B.Com
CA Finalist & Completed B.com
1,078 satisfied customers
QUESTION 18 Suppose you just won the state lottery, and you
QUESTION 18Suppose you just won the state lottery, and you have a choice between receiving \$2,025,000 today or a 20-year annuity of \$250,000, with the first payment coming one year from today. What ra… read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
You are to submit the tax return which is generated by
You are to submit the tax return which is generated by Appendix A, Phases One and Two. Phase Two builds on Phase One. Pay close attention, because some of the new information in Phase Two may change t… read more
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
PROBLEM 1 Big Sky Hospital plans to obtain a new MRI that
PROBLEM 1 Big Sky Hospital plans to obtain a new MRI that costs \$1.5 million and has an estimated four-year useful life. It can obtain a bank loan for the entire amount and buy the MRI, or it can obta… read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
I need assistance in completing this tax return. Noah and
hi i need assistance in completing this tax return … read more
Manal Elkhoshkhany
Bachelor's Degree
909 satisfied customers
I need help with my finacial management homework. A new
Hello, I need help with my finacial management homework … read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
Answer true or False and explain fully 1) When accounting
Answer true or False and explain fully 1) When accounting for investments, significant control leads touse of the equity method of accounting for balance sheet valuation and income statement recogniti… read more
F. Naz
B.Com
CA Finalist & Completed B.com
1,078 satisfied customers
I am currently completing my MPA and I just learned that I
Hello! I am currently completing my MPA and I just learned that I have to conduct an interview with an HR leader, or someone with an HR background, by this weekend. I appreciate your time and thoughtf… read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
I have a Finance project I am working on and need help. The
I have a Finance project I am working on and need help. The project involves an industry analysis and fundamental analysis ***For Manal Elkhoshkhany only***… read more
F. Naz
B.Com
CA Finalist & Completed B.com
1,078 satisfied customers
I have a case to do, can I sent it to you? DSW is a midsized
DSW is a midsized coal mining company with 20 mines located in Hessen region in central Germany. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the spot market.The coal mining industry, especially high-sulfur coal operations such as DSW, has been hard-hit by environmental regulations and warmer than expected winter 2013/2014 and 2014/2016. Recently, however, a combination of increased demand for coal and new pollution reduction technologies has led to an improved market demand for high-sulfur coal. DSW has just been approached by SudenKraftwerk Company with a request to supply coal for its electric generators for the next four years. DSW does not have enough excess capacity at its existing mines to guarantee the contract. The company is considering opening a strip mine in Broken on 5,000 acres of land purchased 10 years ago for € 5 million. Based on a recent appraisal, the company feels it could receive € 6.2 million on an after-tax basis if it sold the land today.Strip mining is a process where the layers of topsoil above a coal vein are removed and the exposed coal is removed. Changes in mining regulations now force a company to reclaim the land; that is, when the mining is completed, the land must be restored to near its original condition. The land can then be used for other purposes. Because it is currently operating at full capacity, DWS will need to purchase additional necessary equipment, which will cost € 78 million. The equipment will be depreciated on a seven-year linear basis. The contract runs for only four years. At that time the coal from the site will be entirely mined. The company feels that the equipment can be sold for 60 percent of its initial purchase price in four years. However, DSW plans to open another strip mine at that time and will use the equipment at the new mine.The contract calls for the delivery of 500,000 tons of coal per year at a price of €85 per ton. DWS feels that coal production will be 620,000 tons, 680,000 tons, 690,000 tons, and 590,000 tons, respectively, over the next four years. The excess production will be sold in the spot market at an average of € 80 per ton but the spot prices are highly volatile. The fact should be taken into consideration in the analysis. Variable costs amount to € 27 per ton, and fixed costs are € 3,700,000 per year. The mine will require net working capital (NWC) level of 5 percent of sales. The NWC will be built up in the year prior to the sales.DSW will be responsible for reclaiming the land at termination of the mining. This will occur in year 5. The company uses an outside company for reclamation of all the company's strip mines. It is estimated the cost of reclamation will be € 2.4 million. After the land is reclaimed, the company plans to donate the land to the state for use as a public park and recreation area. This will occur in year 6 and result in a charitable expense deduction of € 6.5 million. DSW faces a 19 percent tax rate. Assume that a loss in any year will result in a tax credit.You have been approached by the CFO of the company with a request to analyze the project.Calculate the payback period, profitability index, net present value, internal rate of return for the new strip mine. Please prepare also sensitivity analysis for the project assuming that the WACC of the company equals 10%Should DSW Mining take the contract and open the mine taking into consideration the risk of the project? … read more
F. Naz
B.Com
CA Finalist & Completed B.com
1,078 satisfied customers
On January 1, 2014, Seller Corp and Buyer Corp closed on the
On January 1, 2014, Seller Corp and Buyer Corp closed on the sale of a factory building for \$30,000,000 with the following payment terms: Buyer Corp paid \$3,000,000 at closing. Buyer Corp assumed \$7,0… read more
Dr. Donna Kakonge
Doctor of Education
189 satisfied customers
I need help with accounting homework, Business Transactions
Business Transactions for May 1978: May 1 XXXXX XXXXXpher invested \$10,000, a building worth \$20,000, and supplies valued at \$5,000 in the business. May 4 Purchased \$15,000 of equipment, paying \$1,000 cash and signing a two-year, 10% note payable for the remainder. May 7 Rendered services to customers for \$3,000 cash and \$8,000 on credit. May 10 Used up \$1,000 worth of supplies. May 11 Paid salaries of employees \$2,000. May 25 Paid rent for May, \$900. May 30 Borrowed \$10,000 from the Third National Bank, signing a 90 day, 10% note. … read more
F. Naz
B.Com
CA Finalist & Completed B.com
1,078 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less