Construct a line chart of each data set, and use the Add Trendline tool to determine the best-fitting functions to model these data sets.

/in /by

1. Each worksheet in the Excel file Line Fit Data contains a set of data that describes a functional relationship between the dependent variable y and the independent variable x . Construct a line chart of each data set, and use the Add Trendline tool to determine the best-fitting functions to model these data sets. 2. Develop a spreadsheet model to determine how much a person or a couple can afford to spend on a house. 2 Lender guidelines suggest that the allowable monthly housing expenditure should be no more than 28% of monthly gross income. From this, you must subtract total nonmortgage housing expenses, which would include insurance and property taxes, and any other additional expenses. This defines the affordable monthly mortgage payment. In addition, guidelines also suggest that total affordable monthly debt payments, including housing expenses, should not exceed 36% of gross monthly income. This is calculated by subtracting total nonmortgage housing expenses and any other installment debt, such as car loans, student loans, credit card debt, and so on, from 36% of total monthly gross income. The smaller of the affordable monthly mortgage payment and the total affordable monthly debt payments is the affordable monthly mortgage. To calculate the maximum that can be borrowed, find the monthly payment per $1,000 mortgage based on the current interest rate and duration of the loan. Divide the affordable monthly mortgage amount by this monthly payment to find the affordable mortgage. Assuming a 20% down payment, the maximum price of a house would be the affordable mortgage divided by 0.8. Use the following data to test your model: total monthly gross income = $6,500; nonmortgage housing expenses = $350; monthly installment debt = $500; monthly payment per $1,000 mortgage = $7.258.

 

PLACE THIS ORDER OR A SIMILAR ORDER WITH homework handlers TODAY AND GET AN AMAZING DISCOUNT

get-your-custom-paper

The post Construct a line chart of each data set, and use the Add Trendline tool to determine the best-fitting functions to model these data sets. appeared first on homework handlers .

Describe the use of internal rate of return (IRR), net present value (NPV), and the payback method in evaluating project cash flows.

/in /by

Subject: Business    / Finance
Purpose of Assignment
The purpose of this assignment is to allow the student to calculate the project cash flow using net
present value (NPV), internal rate of return (IRR), and the payback methods.
Assignment Steps
Resources: Corporate Finance
Create a 350-word memo to management including the following: Describe the use of internal rate of return (IRR), net present value (NPV), and the payback
method in evaluating project cash flows. Describe the advantages and disadvantages of each method. Calculate the following time value of money problems:
1. If you want to accumulate $500,000 in 20 years, how much do you need to deposit today
that pays an interest rate of 15%?
2. What is the future value if you plan to invest $200,000 for 5 years and the interest rate is
5%?
3. What is the interest rate for an initial investment of $100,000 to grow to $300,000 in 10
years?
4. If your company purchases an annuity that will pay $50,000/year for 10 years at a 11%
discount rate, what is the value of the annuity on the purchase date if the first annuity
payment is made on the date of purchase?
5. What is the rate of return required to accumulate $400,000 if you invest $10,000 per year for
20 years. Assume all payments are made at the end of the period.
Calculate the project cash flow generated for Project A and Project B using the NPV method. Which project would you select, and why? Which project would you select under the payback method? The discount rate is 10% for
both projects. Use Microsoft® Excel® to prepare your answer. Note that a similar problem is
in the textbook in Section 5.1. Sample Template for Project A and
Project B: Show all work.
Submit the memo and all calcluations.

 

PLACE THIS ORDER OR A SIMILAR ORDER WITH homework handlers TODAY AND GET AN AMAZING DISCOUNT

get-your-custom-paper

The post Describe the use of internal rate of return (IRR), net present value (NPV), and the payback method in evaluating project cash flows. appeared first on homework handlers .

How effective are the interactions between the CEO and board and general management regarding declining stock prices?

/in /by

Subject: Mathematics    / Statistics
How effective are the interactions between the CEO and board affect their duties and responsibilities?
How effective are meetings as far as cooperation and achieving objectives go?
How effective is the CEO in providing the board with the required information at meetings?
How effective is the CEO in providing incentives for the performing department of the management after an achievement, for motivation purposes?
How effective is General Management in interacting with the CEO and board in times of need such as emergencies that require urgent solutions to be found?
How effective is the CEO in being approachable by management?
How effective is the board in carrying out self-evaluation in respect to the performance of itself?
How effective is the CEO in carrying out self-valuation respect to the performance of himelf or herself ?
How effective is the CEO’s handling regarding disputes with management?
How effective is the communication between the board and the CEO, overall?
How effective is the communication between the CEO and general management?
How effective is the CEO and board in their interactions in determining strategies for cost-cutting?
How effective is the board and CEO with their interactions regarding the maximization of profits?
How effective is the board and CEO in interactions regarding services and products and whether or not they can be improved?
How effective are the steps taken by the CEO and board regarding corporate social responsibility (CSR)?
How effective is the CEO and board in their interactions regarding bad performance regarding the corporation and/or the stock market?
How effective is the CEO and board in their interactions to discuss strategies when stock prices are going down?
How effective is the CEO and board regarding the satisfaction of the
shareholders? How effective are the CEO and board in their interactions to discuss strategies in debt reduction?
How effective is the CEO and board in their interactions regarding future plans for profitability and/or expansion?
How effective is the communication between the CEO and board regarding strategies when the level of the shareholders’ satisfaction is not good?
How effective are the interactions between the CEO and board regarding financial performance?
How effective are the interactions between the CEO and board when there is a dispute over the financial performance and how these issues are solved?
How effective are the interactions between the CEO and board when there are adverse financial performance indicators?
How effective are the interactions between the CEO and board when the financial performance improves and the stock prices improve?
How effective are the interactions between the CEO and board when the financial performance improves and the stock prices decrease?
How effective are the interactions between the CEO and board when the financial performance decreases and/or the stock prices decrease?
How effective are the interactions between the CEO and board when the
financial performance decreases and the stock prices increase for no apparent reason?
How effective are the interactions between the CEO and board when there are
opportunities for expansion, yet there is a dispute between the CEO and board?
How effective are the interactions between the CEO and board and general management regarding declining stock prices?
How effective are the interactions between the CEO and board and general
management regarding increasing stock prices?

 

PLACE THIS ORDER OR A SIMILAR ORDER WITH homework handlers TODAY AND GET AN AMAZING DISCOUNT

get-your-custom-paper

The post How effective are the interactions between the CEO and board and general management regarding declining stock prices? appeared first on homework handlers .

What are the benefits of studying sociology?

/in /by

Question
I need more than 5 sentences each answer. And I want simple and easy ????

Discussion Questions:

1. What are the benefits of studying sociology? That is, in what ways does understanding the social world make us better people? Better citizens? Better prepared for our careers? (See the “Seeing Sociology in Your Everyday Life” essay in MySocLab).

2. Which of the social sciences (for example: psychology, political science, economics, anthropology, gender studies) strikes you as closest to sociology? Which is most distinct? Why?

3. Sociologists and political scientists both study political behavior. Sociologists and economists both study economic behavior. Is this simply duplication of effort, or do sociologists, with their characteristic perspectives, have the ability to develop insights that might not occur to their colleagues in other departments?

4. Sociologists have in the past several decades developed and refined a specialization called applied sociology. Like applied psychology, it focuses on coping with problems rather than studying what causes those problems. In what ways can sociology contribute to the more effective resolution of social problems at the individual, group, and community levels? Should we promote development of this subdiscipline or would it be better left to the social workers?

 

PLACE THIS ORDER OR A SIMILAR ORDER WITH homework handlers TODAY AND GET AN AMAZING DISCOUNT

get-your-custom-paper

The post What are the benefits of studying sociology? appeared first on homework handlers .