mortgage underwriting

1. An office building has 100,000 sf of rentable space which is occupied by 10 tenants. The largest tenant has a lease expiring in two years with no options. The debt service coverage ratio on a new loan is 1.35x. If the tenant does not renew its lease, the debt service coverage ratio will drop to 1.05. The bank’s minimum requirement is 1.30x.

How does a lender mitigate the potential risk of the tenant vacating the property and still make a prudent loan?

2. Two side-by-side identical industrial buildings are leased to different tenants. One is leased to a national credit tenant for $12.00/sf for 20 years. The other is leased to a local company for $14.00/sf for 5 years with no options. The buildings are in a newly developed industrial park which is expected to be in demand in the coming years due to the expansion of the interstate. 

Which building is worth more? Why?

 

3. You have received an application from a wealthy developer who is building a shopping center. The developer has built six similar centers in the past ten years and still retains ownership in three of them. You have no loans to this principal. Developer has interest from some tenants to occupy the space when it is completed, given this tenant-landlord relationship in other shopping centers. Your analysis of the deal makes sense to finance the loan but during your due diligence, you have found that an office building development that the principal built 12 years ago was foreclosed on by the lender. The lender lost money on the project. You discussed with the principal, who advised that the office market was soft at that time and when they completed it, tenants did not rent the property, which led to the foreclosure. It was also pointed out that it occurred a long time ago and on an office project – not a shopping center.

Do you proceed with the loan? Why? Or why not?

4. You are financing an office building for an existing borrower of the bank.

What are the first few steps you take in your initial analysis to decide if the loan is worth recommending to the loan committee?

fundemental of data systems

    

SQL Individual Assignment

Assume that Orion Star Sports & Outdoors Co. has engaged you as a consultant to advise them on business strategies to increase sales. Study the data tables from this perspective. The most important tables in this data set are:

+ orders + product_line

+ products + profit 

1. Answer the following questions in general:

a) What are the key business questions that can be asked and answered using this data?

b) How does each table relate to answering those questions?

c) How do I have to link the tables in order to be able to answer those questions?

2. For each field in the four tables, answer the following specific questions:

a) Is this a question field, an answer field, or a link field? In other words, is this a key dimension along which I wish to analyze the data (question field), a data item that I want to “slice and dice” along selected dimensions (answer field), or a field that simply helps me link from one table to another?

b) What data type is represented by this field (e.g. integer, text, symbols, currency, etc.)?

c) Are there missing or null values in the data for this field?

d) For range fields (e.g. dates and numbers), what is the range of values in the data? What are the maximum and minimum values?

e) What do you think is the purpose of this field?

f) What questions would you ask the company about this field?

3. Prepare spreadsheets that answer the following questions:

a) What are the top 10 products for orders (by dollar volume)?

b) What are the top 10 countries for orders (by dollar volume)?

c) What are the top 10 selling products by units? By dollar volume?

d) For top two US states and top two countries (excluding the US) in questions 1 and 2, what are the 5 top selling products by units? By dollar volume?

e) Provide the customer ID’s, order dates, and order amounts for all customers who have ordered more than once.

final

 

For this assignment, you will choose a company with which you are familiar. You are encouraged to choose a company for which you currently work or have worked, but you may choose some other firm if you believe it will be a compelling analysis.

You may choose one area of the company, such as a manufacturing plant or product design, to focus on if you can make a strong case. Your recommendations should have the following features.

  • Repeatable: If you “fix” three things in a manufacturing plant, you should be able to tackle the “next” three in iteration.
  • Scalable: If they work in one plant, they should work in all of them.
  • Replicable: Your process for improvement should be repeatable in different, disparate parts of the organization.

This is a key initiative at the “C” level, and your recommendation will reach the board of directors.

Your paper must include the following sections:

  1. Strategic Overview: (1 page)
    Provide a brief description of the following elements:

    1. The company, including its products or services
    2. Marketing strategy: target market segments, value proposition, market position, and source of competitive differentiation
    3. Organizational structure
    4. Any other relevant facts
  2. Analysis of the Supply Chain: (4 pages)
    Analyze the supply chain for your identified company by explaining the following key elements of the supply chain:

    1. Identify key inputs, including less tangible assets, such as human resources and information. How are these key inputs sourced, reconfigured into a product or service, and delivered to your customers?
    2. Identify the key processes that add value, and evaluate the supply chain performance relative to the competition. What are the key inputs for each process? How are these inputs processed or configured into the final offering for your customers?
    3. What is the value added at each step?
    4. What is the role of information technology and e-commerce in serving your customers?
    5. What are the key performance measures for evaluating your supply chain?
    6. Research online sources to explain how the performance on these measures compares to that of your competitors?
  3. Plan to Improve Operating Processes: (3 pages)
    Create a plan for improving the performance of three specific operating processes in your company. Your plan should address the following:

    1. Identify three elements of the supply chain that you recommend as targets for improvement.
    2. State the performance improvement opportunity for each element, and indicate how it will improve process speed, quality, efficiency, and productivity.
    3. Explain what specific action or change you recommend for each supply chain element selected.
  4. Explanation of the Results of Performance Improvements Regarding Product or Service: (2 pages)
    Explain the following:

    1. How will your product or service be improved as a result of these changes to the supply chain activities?
    2. How are you altering the specific features or attributes of your product or service?
    3. Why are these specific changes important to your customers?
    4. How do these changes enhance the value proposition and competitive position of your company?
    5. What lasting capabilities and improvement are you introducing into your company through these changes?
    6. How will you measure the scope and impact of your improvements? What are your key performance indicators?
  5. Assessment of the Impact on Human Resources: (1–2 pages)
    Detail how your plan impacts your company’s HR and human capital strategy by explaining how the organization’s structure supports the new process configuration you are recommending. Your response should address the following questions:

    1. Are the roles and responsibilities in your organization properly defined and aligned to enable these changes? Who will perform these new/modified process activities, and what changes to their jobs do you anticipate?
    2. Is decision-making authority assigned so that the process changes you propose can be implemented and properly managed under the current structure? Who will own the process and the results? Based on the current structure, will they have the authority to make changes as necessary?
    3. Are the individuals with the right skills in place to implement these changes? If not, how will you attract the talent necessary to implement your changes? How will you retrain the existing employee base? How will you handle attrition? How will you reduce the risk of impacted protected classes?
  6. Changes:
    Explain changes to the compensation and incentives at your company that are necessary to reinforce your recommendations and increase efforts for continuous improvement throughout the organization. Explain how your plan motivates employees, customers, and suppliers better.

Write an 5-pages paper in Word format. You may rearrange the above sections if it improves the quality of your paper. Apply APA standards to citation of sources. Use the following file naming convention: LastnameFirstInitial_M5_A1.doc.

Impact of Determinants of Health

 PLEASE READ FULL INSTRUCTIONS. NO PLAGIARISM! NO QUOTES, MUST PARAPHRASE. I WILL CHECK FOR RECYCLED WORK AND PLAGIARISM, SO WILL THE TEACHERS. PLEASE USE THE GRADING RUBRIC. THIS WILL ENSURE EVERYTHING NEEDED FOR THE PAPER IS COMPLETE. THIS ASSIGNMENT IS DUE 06/28/21 AT 9PM PST. IF YOU CANT MEET THIS DEADLINE OR FOLLOW DIRECTIONS, DONT AGREE TO DO MY ASSIGNMENT. PRICE ISNT NEGOTIABLE. 

 

Prior to beginning work on this assignment, please read the A National Partnership for Action to End Health Disparities in The United States (Links to an external site.) article. Based on the table you created in the Levels of Determinants discussion forum:

Identify the two levels of determinants that you feel have the most impact on health (individual, household, community, etc.).

  • Once you have selected your levels, conduct your own research and discuss what factors associated with those levels support your claim that they have the most impact on health.
    • Use scholarly research to support your reasoning.
  • Next, choose a health factor related to one of the determinants from one of your classmates’ tables and assess the impact of that determinant on the nation’s health.
    • For example, if your classmate chose age as the determinant under the Individual level, some health issues related to age are osteoporosis, vision, and hearing loss, Alzheimer’s disease, poor decision making, or juvenile diabetes.
    • Use scholarly research to support your assessment.
  • Propose a new initiative to address this health factor you chose.
    • Include information on your target audience, population size, predominant locations, etc.
    • Use scholarly research to support your reasoning.
  • Recommend two links or pathways between the levels of determinants that will be appropriate for your initiative given the target audience and location you identified.
    • For example; if you chose Age as your health factor under the Individual level, then discussing Household and National initiatives could be appropriate.
    • Use scholarly research to support your reasoning for each link/pathway.
  • Justify how the links you identified between the levels will better address the health factor you researched.
    • Use scholarly research to support your reasoning for each link/pathway.

The Impact of Determinants on Health paper

  • Must be four to six double-spaced pages in length (not including title and references pages) and formatted according to APA Style as outlined in the Ashford Writing Center’s APA Style (Links to an external site.)
  • Must include a separate title page with the following:
    • Title of paper
    • Student’s name
    • Course name and number
    • Instructor’s name
    • Date submitted

For further assistance with the formatting and the title page, refer to APA Formatting for Word 2013 (Links to an external site.).

Must include a separate references page that is formatted according to APA Style as outlined in the Ashford Writing Center. See the APA: Formatting Your References List (Links to an external site.) resource in the Ashford Writing Center for specifications.

Carefully review the Grading Rubric (Links to an external site.) for the criteria that will be used to evaluate your assignment.

Nubbles and Rudge decide to rob the Tight Fist Bank.

 

Nubbles and Rudge decide to rob the Tight Fist Bank. They make elaborate plans and purchase some firearms to assist them in their venture.

criminology

Description

THE THREE QUESTIONS SHOULD BE 400-500 WORD EACH AND PLEASE USE CITATIONS AND DO NOT COPY AND PASTE (NO PLAGIARISM)

1. Nubbles and Rudge decide to rob the Tight Fist Bank. They make elaborate plans and purchase some firearms to assist them in their venture. https://academicessly.com/2021/05/03/learn-more-about-the-history-of-the-united-states-census-by-visiting-https-www/ On the appointed day, they drive to a street corner just one block away from the bank; they intend to observe the bank for a while and then undertake the robbery at the most appropriate moment.  However, a police cruiser passes by and the two officers notice that Nubble and Rudge look suspicious.  The officers arrest the would-be bandits when they find two sawed-off shotguns and two masks on the back seat of the car.  Nubbles and Rudge are subsequently charged with attempted robbery.  Are they guilty of this offence?

Discuss the potential criminal liability, if any, of each person mentioned.   Identify, define, and describe relevant concepts and issues. https://iacademicessay.com/2021/06/06/im-working-on-a-business-discussion-question-and-need-support-to-help-me-study-12/

State any assumptions you may need to make to analyze the issues. In your response, consider course materials, case law, legislation, any contributions to the optional discussion forums, and any other resources you consider relevant.

2. Cruncher and Slammer are professional hockey players who are playing on opposing teams. As Cruncher is carrying the puck, Slammer pushes him into the boards along the side of the hockey rink. An altercation develops between them, and some punches are thrown.  The referee whistles play dead, and after a brief period, the linesmen separate Cruncher and Slammer and lead them toward their respective penalty boxes.  However, Cruncher breaks free from his accompanying linesman and skates up to Slammer and punches him in the eye – to the delight of the local fans. Cruncher is 6 feet 5 inches tall and weighs 280 pounds. Slammer is 5 feet 8 inches tall and weighs 150 pounds. The blow inflicted by Cruncher opens a deep cut underneath Slammer’s eye and numerous stitches are required to close the wound. Cruncher is charged with assault causing bodily harm.  Does cruncher have any defence(s)?

In addition to the question posed above, please discuss the Instructor’s addition to the fact pattern as follows:

Mandy was sitting in the audience at the hockey rink. She was so distressed and upset by seeing Slammer injured, with all the blood on the ice, that she became dazed and disoriented. She grabbed her umbrella and repeatedly hit a nearby woman on the head with it, injuring her. Several hockey fans had to intervene to stop Mandy from hitting the woman, and they would later tell the police that Mandy had a blank look, and did not seem to be normal. https://getacademicessay.com/6590/practicum-i-pulls-together-several-of-the-ideas-discussed-so-far-this-semester/

Discuss the potential criminal liability, if any, of each person mentioned.  Identify, define, and describe relevant concepts and issues.

State any assumptions you may need to make to analyze the issues. In your response, consider course materials, case law, legislation, any contributions to the optional discussion forums, and any other resources you consider relevant.

3. A federal politician, Ronald Thump, has recently announced that the Canadian government will amend the criminal law to reduce the number of defences available to accused persons. In particular, the government intends to completely eliminate the defence of necessity or duress.

“With one of these defences eliminated, there will be cost savings in the criminal justice system.  Canada has far too many defences available to accused persons, resulting in court delays and increased costs,” Mr. Thump stated. “One of these defences has got to go.  The public is confused about these two defences, and too many criminals are getting off on these technicalities.”

Mr. Thump has asked you, his Special Advisor, to prepare an opinion for him on which defence to eliminate:  necessity or duress. He wants a clear Recommendation from you, with reasons for your choice.

In your opinion, you must describe both defences in detail and provide examples.

Business law Discussion post

Part A:

Intellectual Property is the life blood of many corporations and organizations. Without the protections afforded by the U.S. legal systems, organizations may never invest in research and development. Currently, patents provide inventors up to 20 years of protection and copyrights can vary in year of protection, but is most commonly protected for the life of the creator plus 70 years or more. However, many other countries do not provide a similar level of protection afforded to intellectual property and in fact may not enforce protections at all.

Discuss what you believe is the best way for an organization to protect its intellectual property in a global economy.        Must be 100-150 words.

Part B: 

To demonstrate how planning, organizing, and decision making are applied in the workplace, this week’s discussion will involve researching an article using one of the following sources:

  • USA Today (www.usatoday.com)
  • Wall Street Journal (www.wsj.com)
  • New Your Times (www.nytimes.com)
  • Forbes (www.forbes.com)
  • Bloomberg Business Week (www.bloomberg.com)
  • Inc. Magazine (www.inc.com)
  • Economist (www.economist.com)
  • Entrepreneur (www.entrepreneur.com)
  • Harvard Business Review- (www.hbr.org)

Your task is to choose a current article (published in last 60 days) from one of the above-listed sources that relate to how managers plan and/or organize their responsibilities.

  • What additional skills or knowledge do managers need to carry out their planning and organizing functions?
  • What key points in the article support your statements?

Copy and paste the URL address of the article so it can be easily shared with your classmates. Must be 100-150 words

Emerging Threats

Research Paper  

A new medium-sized health care facility just opened and you are hired as the CIO. The CEO is somewhat technical and has tasked you with creating a threat model. The CEO needs to decide from 3 selected models but needs your recommendation. Review this week’s readings, conduct your own research, then choose a model to recommend with proper justifications. Items to include (at a minimum) are:

  • User authentication and credentials with third-party applications
  • 3 common security risks with ratings: low, medium or high
  • Justification of your threat model (why it was chosen over the other two: compare and contrast)

You will research several threat models as it applies to the health care industry, summarize three models and choose one as a recommendation to the CEO in a summary with a model using UML Diagrams (Do not copy and paste images from the Internet). In your research paper, be sure to discuss the security risks and assign a label of low, medium or high risks and the CEO will make the determination to accept the risks or mitigate them. Your paper should meet the following requirements:

  • Be approximately four to six pages in length, not including the required cover page and reference page. (Remember, APA is double spaced)
  • Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.

Life Span and Women Health (Due 24 hours)

 

1) Minimum 3 full pages (Follow the 3 x 3 rule: minimum three paragraphs per part)

             Part 1: Minimum 2 pages

             Part 2: minimum 1 page

            

Submit 1 document per part

2)¨******APA norms

          All paragraphs must be narrative and cited in the text- each paragraphs

          Bulleted responses are not accepted

          Dont write in the first person 

          Dont copy and pase the questions.

          Answer the question objectively, do not make introductions to your answers, answer it when you start the paragraph

Submit 1 document per part

3)****************************** It will be verified by Turnitin (Identify the percentage of exact match of writing with any other resource on the internet and academic sources, including universities and data banks) 

********************************It will be verified by SafeAssign (Identify the percentage of similarity of writing with any other resource on the internet and academic sources, including universities and data banks)

4) Minimum 3 references per part not older than 5 years

5) Identify your answer with the numbers, according to the question. Start your answer on the same line, not the next

Example:

Q 1. Nursing is XXXXX

Q 2. Health is XXXX

6) You must name the files according to the part you are answering: 

Example:

Part 1.doc 

Part 2.do

__________________________________________________________________________________

Part 1:  Life Span

Topic: Common Respiratory Complaints

A 75-year-old man with a history of hypertension, diabetes, environmental allergies, and colon polyps presents to the office with a complaint of persistent dry hacking cough that does not improve with over-the-counter treatment with antitussives and allergy medications. The man reports that he has had the cough for three months and is tired of the coughing spells he experiences. His medical history reveals that he started taking lisinopril six months before this appointment, has taken an over-the-counter allergy medication for several years, had his last colon polyps removed six years ago, and his blood pressure today is 145/70. Other medications include metformin XR 500 mg daily, aspirin 81 mg once daily, and loratadine 10 mg daily. The physical exam is negative for any issues other than his mild neuropathy from long-term diabetes. The cough is noted to be dry and hacking as the patient has described. The man is not in acute distress.

Case Questions:

1.Using OLDCARTS, what questions would have been asked as part of the medical history?

2. What physical aspects would have been completed as part of the physical exam and why? Include the diagnostics that you would order and rationale.

3. Based on the medical history and physical exam, what is the most likely cause of his cough?

4. What other possible diagnoses should be considered and why?

5. Are there any other tests that should be completed before producing a diagnosis? Why or why not?

6. What is the treatment for this patient, including education?

Part 2:  Women Health

 Explore federal agencies that are concerned with women’s health. 

1. Which ones may be of benefit to vulnerable populations? 

2. Explore and describe nonprofit agencies that are concerned with women’s health. 

3. Share resources aimed at benefitting women in your state or area (Florida).

FINANCIAL ACCOUNTING

PRICE IS NEGOTIABLE

Week 6 Assignment: Course Project – Part 2

Assess your business:Fast forward a few months… Your friend asks you how your business is doing and you are unsure how exactly to answer. In fact, you are not necessarily sure how your business is doing since you are so new to this! This part will help you organize your thoughts and come up with a more formalized process and financial reporting can help you demonstrate your success (or lack thereof!).For your cart, come up with a way to determine profit and financial position. Expand your Excel spreadsheet from Part 1 by adding an additional tab. There is no specific format for this. Data should be reasonable based on your projections from Part 1 and include all expenses. Your grade is not dependent on whether you are making a profit.Use the momentum from the discussion forums from Weeks 3 & 5 where we collectively brainstormed methods of determining if the business was profitable and how to measure profitability in a professional format.Include an analysis that summarizes your findings in a professional manner.This part of the project should be approximately 2 – 4 pages, including the financials.

IF YOU CAN HELP WITH THIS PLEASE GET BACK TO ME ASAP PRICE IS NEGOTIABLE!!!

4mat review

Please review the following course text: Sire, The Universe Next Door: A Basic Worldview Catalog (2009).

Also, please use the following format in preparing your 4-MAT Book Review: 

  1. Title Page: Remember to include a Title page that meets APA guidelines
  2. Summary:  Summarize what you have read as if you were the author boiling down the book into 200 to 250 words.  Prove that you comprehend the readings by describing the biblical worldview of the author and text and the central themes communicated in the book. Citations required.
  3. Concrete Responses:  Get vulnerable!  In 250 to 300 words, relate a personal life episode that this book connected with in your own life experience.  Relate your story in first person, describing action, quoting sentences you remember hearing or saying.  In the teaching style of Jesus, this is a do-it-yourself parable, case study, confession.  You will remember almost nothing you have read unless you make this critical, personal connection.  What video memory began to roll?  This is your chance to tell your story and make new ideas found in the book your own. In this section, you can use first person meaning the words “I,” “we,” ‘us,” and “you.” No citations required.
  4. Reflection:  Please consider the content of the reading assignment and include any further questions the material brings to mind.  Keep a rough note sheet at hand as you read.  Begin with questions like, “What would I like further information on?” Where do I not agree/strongly agree with the author?” or “What bothers me/excites me about this content?”  This section should be at least 250 to 300 words. In this section, you can use first person meaning the words “I,” “we,” ‘us,” and “you.” No citations required. 
  5. Application:  How does information book influence how you are going to continue your own personal growth process?   What actions or changes are you going to make in your life as a result of your learning?  Your response here is a matter of obedience first, questions later.  Be precise in summarizing your action steps (limit these comments to about 150 to 200 words). In this section, you can use first person meaning the words “I,” “we,” ‘us,” and “you.” No citations required.
  6. Include Reference Page: Remember to include a reference page that identifies the book in APA format.