Loan Amortization

Develop a macro that will calculate the monthly payment for a loan given the following:

The loan amount i.e. principal (dollars)

The annual interest rate (%/yr)

The number of years to pay off the loan (yrs)

Use the InputBox command to give default input values based on the last case you ran.

Base the monthly payment according to the formula:

a = p(i)(1+i) n / ( (1+i) n – 1 )

Generate a table with headings showing the month number, the monthly payment, the

monthly interest, the amount applied to the principal, and the new balance.

Generate the tables for the following cases:

  1. p=$25,000, I=5%, N=5 yrs
  2. p=$25,000, I=6%, N=6 yrs
  3. p=$400,000, I=5%, N=30 yrs
  4. p=$400,000, I=5%, N=10 yrs
  5. p=$400,000, I=6%, N=30 yrs
  6. p=$400,000, I=5%, N=30 yrs, round monthly payments and interest

to the nearest penny

In your report, show an abbreviated payment schedule of the first six and the last 6

payments for each case. Discuss your findings.

Sample Solution

The post Loan Amortization appeared first on homework handlers.

Fundamentals of User Experience Design (UXD)

Q1:Describe in details any 3 fundamentals of User Experience Design (UXD). Use your own words but cover the elements discussed in the class.

Q2:Digital Marketing vs Traditional Marketing: Which Produces Better ROI? List out 5 benefits of Digital Marketing, explaining in your words, how it is better

than Traditional Marketing?

Q3:List out at least 5 (you can do more if you have time) Online Business Models available to businesses and give example for each of them, explaining the

differences among them

Q4:Name the 4 pillars of search marketing funnel? Explains in your words some of the topics/ideas related to each of these pillars as discussed in the class.

Q5:Describe any 4 Link building strategies discuss in the class in relation to Search Engine Optimization, why they are important and how you can you use them

to optimize your search results.

Sample Solution

The post Fundamentals of User Experience Design (UXD) appeared first on homework handlers.

Econometrics

Using the data set to run a regression, report results, and report which coefficients are statistically significant at 0.05.

Sample Solution

The post Econometrics appeared first on homework handlers.

Interviewing a nurse.

It can be any current licensed nurse still practicing in any type of nursing (not a nursing student, a retired nurse or someone who left nursing to pursue

another career/profession). The goal is to gain insight into nursing practice today and how it has evolved.

Ask the interviewee the following questions:

  1. How long have you been a nurse?
  2. What health care delivery system do you work in?
  3. What historical, societal, political and/or economic events have had an impact on nursing practice?
  4. Since you became a nurse what is one major challenge you have faced in the delivery of quality patient care?
  5. Do you have any words of wisdom for a brand new nursing student to survive nursing school or the transition to nursing practice?

Sample Solution

The post Interviewing a nurse. appeared first on homework handlers.