Determine how many years it will take to pay off the loan (cell E18). Inputs do not have to be explicitly listed elsewhere.

1
Real World Project 2
Evaluating Loan Options for Flowers By Diana
Diana Bullard currently rents space for her small florist business. As her business continues to
grow, Diana has decided to purchase her own building. She has selected a site and now requires
financing. After meeting with several banks to discuss financing options for a mortgage, Diana
has the data she needs to analyze her options. She lists the purchase price of the building and the
different values for each of the loan variables together with the other data inputs in an Excel
workbook named Loan.xlsx. Her analysis must also take into account the following:
Down paymentThe amount of money Diana will pay at the time she purchases the
building. Provided is the percent of the building purchase price that will be required for a
down payment on each corresponding loan. The difference between the sale price and the
down payment is the loan valuethe face value of the loan.
PointsThe additional charges banks sometimes require when lending a mortgage. Banks
usually offer mortgage loans in a variety of interest rate and point combinations. Frequently,
loans with higher points have lower interest rates. One point equals 1% of the loan value, so
one point on a $7,500 loan is $75.
FeesThe additional amounts banks sometimes charge when lending a mortgage. These
amounts vary by bank and loan type. Typical charges include application fees, appraisal fees,
credit report fees, and so on.
Your task is to complete the Loan worksheet for Diana, using cell references whenever possible.
Write the formulas in cells G8 through K8 so that they can be copied down the column to
calculate values for each option. Write the formulas so they will automatically update if the
mortgage value changes. Loan options 17 are all compounded monthly.
Complete the following:
1. Open the workbook named Loan.xlsx. The file is attached to the RWP2 assignment link in
this learning module. Save the file name as FirstName_LastName_LoanAnalysis.xlsx.
2. In the Loan Value column, calculate the face value of this mortgage. The purchase price of
the building is in cell E3.
3. In the Monthly Payment column, calculate the monthly mortgage payment for this loan
amount based on the loan value you just calculated. Use the corresponding loan duration, and
nominal interest rate indicated. Assume that the loan is completely paid off at the end of this
duration. The number of compounding periods per year is in cell E4.
4. In the Actual Amount Borrowed column, calculate the actual amount Diana will borrow by
subtracting the points and fees from the loan value.
5. To take these fees into account, the lender is required by law to disclose the APR (the annual
percentage rate of interest) of the loan being charged. However, banks can calculate APR in
2
different ways, including or excluding different fees. To calculate an actual annual interest
rate being charged on this loan (APR), use the actual amount borrowed (Step 4) as the
present value of the loan, the monthly payment (Step 3), and the corresponding loan duration.
6. In the Payment with Balloon column, use the nominal interest rate and loan value (from
column G) to determine the monthly loan payment if you altered the loan to include a
$20,000 balloon payment at the end of the loan.
7. The building seller has also offered Diana a private loan for 85% of the value of the building.
In return, Diana must pay $4,500 per month for the next 10 years. Determine the annual
interest rate being charged (cell E17). Inputs do not have to be explicitly listed elsewhere.
8. Diana is negotiating with the seller and is willing to pay $10,000 per quarter at 6 % interest
per year compounded quarterly. She will borrow everything but a 10% down payment.

9. Ten years ago, Diana invested $75,000 in a bank CD. The CD has earned 3.25% annual
interest compounded yearly. Determine (TRUE/FALSE) if Diana has sufficient funds from
this CD for the down payment for Option #1 (cell E19).
10. Diana has decided that she prefers a bank loan and, given cash flow issues, wants the loan
with the smallest payment. Highlight in light blue the cell in column H containing the
payment of the loan Diana should select.
11. Save and close the FirstName_LastName_LoanAnalysis.xlsx workbook.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

Consider the abnormal physical characteristics you observe in the graphic you selected. How would you describe the characteristics using clinical terminologies?

________________________________________
Assignment 1: Differential Diagnosis for Skin Conditions
Properly identifying the cause and type of a patients skin condition involves a process of elimination known as differential diagnosis. Using this process, a health professional can take a given set of physical abnormalities, vital signs, health assessment findings, and patient descriptions of symptoms, and incrementally narrow them down until one diagnosis is determined as the most likely cause.
In this Assignment, you will examine several visual representations of various skin conditions, describe your observations, and use the techniques of differential diagnosis to determine the most likely condition.
To prepare:
Review the Skin Conditions document provided in this weeks Learning Resources, and select one condition to closely examine for this Assignment.

Explore different conditions that could be the cause of the skin abnormalities in the graphics you selected.
Consider which of the conditions is most likely to be the correct diagnosis, and why.
Download the SOAP Template found in this weeks Learning Resources.
To complete:
Choose one skin condition graphic (identify by number in your Chief Complaint) to document your assignment in the SOAP
(Subjective, Objective, Assessment, and Plan) note format, rather than the traditional narrative style. Refer to Chapter 2 of the Sullivan text and the Comprehensive SOAP Template in this week’s Learning Resources for guidance. Remember that not all comprehensive SOAP data are included in every patient case.
Use clinical terminologies to explain the physical characteristics featured in the graphic.

Formulate a differential diagnosis of three to five possible conditions for the skin graphic that you chose. Determine which is most likely to be the correct diagnosis and explain your reasoning using at least 3 different references from current evidence based literature.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

What is the role or import of cultural critics like Ai Weiwei, James Baldwin, and Malcolm X, and what are their specific critiques of popular culture, art, and society?

Ai Weiwei is an important Chinese cultural critic and visual artist, and James Baldwin is an important Black American intellectual and writer. Think about their work and reflect upon what they can teach you about the role of art as culture and as cultural critique. Try to think about what the films are saying — how do they fit together?

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

Risk Behaviors for Contracting Communicable Disease

Investigate behaviors that place persons at risk for contracting selected communicable diseases. Knowledge related to the risk of communicable diseases has changed in recent years. Sexually transmitted diseases (STDs), once thought to be a disease of the past, have recently emerged as new diseases and drug resistant strains of old disease. Left untreated, STDs result in poor pregnancy outcomes, infertility, and cervical cancers. There is also a problem with co-infection; one STD increases the susceptibility to other STDs, such as the human immunodeficiency virus (HIV) (Stanhope & Lancaster, 2012, p. 317). Transmission occurs through exposure to blood, semen, transplanted organs, vaginal secretions, and breast milk. Several of the communicable diseases (e.g., Hepatitis B) and all STDs are acquired through high risk behaviors include IV drug use, frequent sexual encounters, unprotected sex, and men who have sex with men are examples of behaviors than can be avoided or changed (Stanhope & Lancaster, 2012, p. 320-321). The groups with the highest prevalence for Hepatitis B are IV drug users, persons with STDs, personals with multiple sex partners, immigrants, health care workers, hemodialysis patients, and inmates of correctional facilities. Hepatitis B cases have declined since the HBV vaccine has become available (Stanhope & Lancaster, 2012, 327-328). The onset of AIDS, HIV, Hepatitis, and drug resistant TB has led to new legislation, increased infection control practices and objectives developed by the Healthy People 2020 Report to evaluate the progress toward decreasing communicable diseases by the year 2020, including reducing the rate of HIV transmission, and reducing the number of new AIDs cases among the vulnerable members of the population (Stanhope & Lancaster, 2012, p. 317). Reference: Stanhope, M. & Lancaster, J. (2012). Public health nursing: Population-centered health care in the community. (8th ed). St. Louis, MO: Mosby. Learning Activity #4: Risk Behaviors for Communicable Disease Discussion Read Chapter 14 in your Stanhope and Lancaster textbook. The increasing incidence, morbidity, and mortality of specific communicable diseases highlight a need for nurses to educate clients about ways to prevent communicable diseases. Write two to three paragraphs that include the following: Use the observations of risky behavior that you observed during the windshield survey. Identify to whom one reports communicable diseases (such as HIV), in the selected community ( DOUGLAS COUNTY – GEORGIA). Discuss the role of the community nurse in providing preventive care for communicable disease Cite a minimum of one source from the scholarly literature.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

Discuss how algorithms address object-oriented classes and objects.2. Choose a value for each of the variables X and Y.

1. Read the following pseudocode class definitions:
Class Plant
Public Module message()
Display “I’m a plant.”
End Module
End Class

Class Tree Extends Plant
Public Module message()
Display “I’m a tree.”
End Module
End Class
Given these class definitions, determine what the following pseudocode will display:
Declare Plant p
Set p = New Tree()
Call p.message()

In pseudocode, write the first line of the definition for a class X. The class should extend the class Y.
Discuss your classmates’ class definitions. Given their class definitions, determine what the following pseudocode will display:
Declare X p
Set p = New Y ()
Call p.message()3 Often programmers are asked to find errors in code that has been created previously, and often not by them or anyone currently with the organization.
Complete the “Debugging Exercise” in Ch. 10, “Files,” of Starting Out with Programming Logic and Design.
Discuss the errors. How could these errors be avoided? See attachment

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

Identify how icon and closure are represented in tht medium. Consider that both ideas are abstract concepts and can take on many forms.

:The focus of this essay is rhetorical analysis. You have been exposed to several methods of rhetorical techniques unique to comics. Or are they? You are now asked with investigating a different medium and analyzing whether/how those rhetorical elements are present in that other medium. You goal is to identify how icon and closure are utilized in that medium as well as to investigate a different rhetorical technique present in that medium. This project will take the form of a formal, analytical essay. Basic essay construction is required (intro, body, conclusion) as well as proper citation of the sources you utilize. Directions:1. Select a medium. You might select from traditional media such as written fiction, television commercials or music. Alternatively, you are free to investigate newer media such as memes, snapchat, remixes, etc. 3. Identify a THIRD rhetorical technique used by the medium that is NOT icon or closure, and investigate how that medium uses that technique and what is accomplishes by doing so. 4. In the form of a formal, analytical essay, explain how both icon and closure manifest in this medium. Also explain your THIRD technique. To better explain them to your audience, you should cite at least three examples of each technique, making sure to explain how they function within the rhetorical situation. 5. If applicable in your analysis, compare the rhetorical methods to rhetorical methods present in Understanding Comics and identify similarities and or difference in how they function. 6. In your essay, evaluate also what there is to be gained through this analysis. Why might is be important to investigate how this medium functions and to whom? Book to reference:
https://elearning.shisu.edu.cn/pluginfile.php/68463/mod_resource/content/0/Understanding%20Comics.pdfRequirements:

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

Within the last ten years how have federal, state and local governments taken advantage of policing, power and violence? Identify various situational processes that sticks out in America today involving this practice.

Violence, policing and power all have a process, sequential actions or predetermined orderly steps taken to achieve a particular outcome or end product. With this concept in mind and the authors research on the attached document (Seigel, M. (2018). Violence work: Policing and power. Race and Class, 59(4), 15-33. doi:10.1177/0306396817752617), discuss your perspective on the following questions: (2) Within the last ten years how have private entities, community groups and political activists taken advantage of policing, power and violence? Identify various situational processes that has been observed or experienced throughout America.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]

What is Pro-Forma Financial Statement and why is it important to a business?

Second Paragraph – What are recommended approaches to prepare Pro-forma Financial Statements for a small business based on your research.Third Paragraph – What is working capital? List one objective of working capital management.Fourth Paragraph – Explain how rapidly expanding sales can drain the cash resources of a company.Fifth Paragraph – What are the sources of short-term asset management / financing strategies?

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]