1). Trace the development of the early church in Jerusalem. 2). Explain the Jerusalem Council in terms of its conclusions and significance for later doctrine. 3). We observed where some men came from

Delivering a high-quality product at a reasonable price is not enough anymore.

That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Respond to Jesus, Rebecca, Tykeisha, and Brittney responses. Jesus post The main difference between the static and flexible b

Respond to Jesus, Rebecca, Tykeisha, and Brittney responses.

Jesus post

The main difference between the static and flexible budgets is that the first one has not changed even inf the volume of activity change. The change volume is the main source of the flexible budgets, in contrast the flexible budges show the revenues and cost to different levels of volume. For this idea the flexible budgets are considerate and extension of static or master budgets.

Flexible budgets work for all kind of companies, I was working in backing for 10 years and I saw this kind of budgets frequently, nowadays I’m in the health industry more specific in the developed and test of drug transporting thousands of samples around the world. Carrier and Q2 Solutions uses these budgets to be able to offer and negotiate better prices depending on our volume of transportation which is based on studies needs. The advantages the flexible budgets offer to my job is having clear vision of how the price of transportation can be affected to different volumes because the revenue to the company depends on this, so if we have a deal whit a new pharmaceutics or a new specific study of drugs is acquired, we can estimate the volume of shipments and the price of the transportation giving us certainty of the possible revenue.

Rebecca post

 When it comes to static and flexible budgets, the most significant difference is that flexible budgets can be altered at any time and therefore is, more flexible, where a fixed budget is predetermined and remains the same. A flexible budget is also more sophisticated as there are be different changes and activity levels to prepare. Static is easier to qualify as there is only one budget and fixed numbers. A business that would benefit most from a fixed budget would be an organization that deals with goods with fixed prices and transactions or government and educational organizations such as schools. At the same time, a flexible budget would be good for the fashion industry as these costs vary by venture and style. Most companies, in my opinion, would use a flexible budget because the amount of money coming into the companies varies by sales and other needs of the company as there are not many companies that sell things that are the same price and item. This would not make a very successful sales business.  

Tykeisha post

To determine a reasonable accommodation for a physically disabled employee, I would first want to know exactly what barriers or limitations does the employee have without violating their privacy. For an example, is there a limit on how much weight can be lifted or carried? Is so, equipment can be used to assist, such as a pull or dolly. Can the employee stand or sit for a prolong period of time? If not a modified work schedule can be used to ensure adequate breaks. Work schedules can also be modified to accommodate health related appointments.

An example of an inappropriate accommodation would be for the employee to change or alter the production standards. If said disability causes the employee to fall short of the company’s production and performance standards, even with the proper accommodations; I would suggest a reassignment to a different department within the company. According to the Equal Employment Opportunity Commission (EEOC) all employees are to be held accountable to the same standards across the board.

Brittney post

First, when a person with a physical disability is hired, they are supposed to ask for accommodations and have a conversation about it with the employer and them. We are assuming this has already been done, and depending on the physical disability, I would try and make their schedule flexible, if they had doctors’ appointments. See if I could get modified devices or equipment for them, to help overcome barriers. Or if the new hire could not stand for long periods of time, provide a stool or some type of chair so they could sit down. Reasonable, and appropriate accommodation should not cost the company, and depending on the type of disability it really is hard to tell which accommodation would be best suitable for them. It could simply be providing a ramp if they are in a wheelchair, providing a chair, putting them on light duty, or changing how the job essential functions are completed or done without replacing the essential functions. I would make sure they enjoy the benefits we offer them, and they have the best suitable accommodation we could offer to them, to make their job efficient.

If they knew hire asked for me to lower production standards, or asking for more paid time off than others, I would say we cannot do this, we must be fair to all employees in our facility, but we have this accommodation for you that we think may be suitable, if not we have other accommodations as well. I would want them to know we are an equal opportunity employer, and that have to be fair to all employees, and cannot provide this accommodation, because we cannot give more paid time off to other employees, or act as if they are receiving special treatment. One resource that I would provide is the U.S Department of Labor, and the second resource is DMEC.org.4

 DISCUSSION QUESTION

Respond to the following in a minimum of 175 words:

Under the Americans with Disabilities Act (ADA), reasonable accommodations must be provided to allow a qualified employee to perform the essential functions of a job. These accommodations could range from reserved parking, to a specific software program, to allowing service animals in the workplace.

Consider a situation in which a person with a physical disability is hired in a car manufacturing company. As his manager, how would you determine a reasonable and appropriate accommodation for your new hire? 

Consider if the new hire requested an inappropriate accommodation, how would you respond? What are 2 resources you could use to support your effort? Discuss your responses and provide links to the resources.

 

  1. How does your view of the importance of the liberal arts compare with that of Tatum and Angel post?
  2. What do you find of value in Tatum and Angel post understanding of the role of innovation in the liberal arts?

Tatum post

Hello, my name is Tatum Florom. I am from a small town in Nebraska. I am studying to be a counselor. The importance of liberal arts to me means that you learn about technology, social skills, the education of history as well as culture. Liberal arts fit in my education because I have to learn all points of view. The impact liberal arts will have in continuing innovation will be big. Things will improve and it will get better and better for everyone. Everything will also be easier to use or do. 

Angel post

Hello everyone, my name is Angel I am 42 years old and perusing a degree in Computer Science. I currently work at a retail pharmacy where I have been a technician for a little over 7 years. I have a fixing to be 2-year-old son that I raise as well as a 5- and 6-year-old grandsons I help raise. Needless to say, my life is far from boring. Liberal Art is a big help in the career that I am perusing because it will help me how to solve problems using more than one point of view. It helps you learn how to look at many different perspectives. Wish everyone luck in this class as well as in the future.

 

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

I need a 3-5 page signature assignment essay done by the 27th. From 1994 to 2001 Jack Abramoff was a top lobbyist for the firm of Preston Gates & Ellis, and then for Greenberg Traurig until Mar

I need a 3-5 page signature assignment essay done by the 27th. From 1994 to 2001 Jack Abramoff was a top lobbyist for the firm of Preston Gates & Ellis, and then for Greenberg Traurig until March 2004.  After being investigated for major corruption charges, he eventually pleaded guilty and served 6 years in federal prison.  He went from being one of the most influential people in Washington D.C. to a convicted felon who can no longer vote.This assignment asks you to watch the documentary at the link below and then answer the questions.  The answers to the questions should be formulated into a formal college level essay.  It should be written in paragraph form (at least one paragraph for each question—many will need more than one paragraph), proof read and edited so that there are no grammar or punctuation issues.  Students who are not great at this should seek help from the Navarro College Tutoring Center or by utilizing Upswing by looking at the red menu on the left-hand side of the screen.  You do not need to seek out sources for this unless you choose to.  If you do choose to use outside sources, they must be legitimate sources (not media outlets) and they absolutely must be cited in the paper and at the end of the paper in a works cited page. When answering the questions, if you do not understand them or do not know about the information referenced in the question…Google it.  If you need help understanding the concept and role of interest groups and lobbyists, please read up on it quickly in Chapter 10!!  You must understand this before you can write the paper!!In It to Win It- The Jack Abramoff Story1. What are the key points that this documentary raises?2. What did Abramoff do that was unethical, even if legal? Why were these actions unethical?3. The documentary focuses on Abramoff’s role as a lobbyist within a system that is, he argues, more corrupt than ever. To what degree do individuals have a responsibility to act ethically within a morally corrupt system?4. The documentary raises the point that white-collar crime is generally considered far less problematic than hard crime. Do you agree? Why or why not? What are the long-term consequences of white-collar crimes for individuals, families, society?5. Do you agree with the UT officials who decided to bring Abramoff to campus in order to speak to students and create this film? What ethical issues were involved in their decision-making process?6. Compare Abramoff’s situation with the Lance Armstrong scandal. What similarities can you identify? What differences? What character traits do you think led each man to act illegally and unethically? Are their actions representative of ‘everything wrong’ (i.e. hunger for power, money, fame) with American society?7. Do you think Abramoff’s success as a lobbyist supports the idea that politicians are corrupt or easily corruptible? Should we place blame on Abramoff and the politicians or the system in which they operate? If the system is fundamentally flawed, is it fair for individual lobbyists or politicians to pay the price?8. In the film, Abramoff notes that he thought he was the ‘moral lobbyist’? Why does he think so and do you agree with him?9. Abramoff still owes the government $44 million in restitution. Some argue that he is only speaking out against corruption to get past this debt and regain his prior fame and fortune. Others believe his claim that he is in a unique position to expose the corruption of the system. Do you believe Abramoff genuinely regrets his prior actions and is now working hard at improving how our government operates? Or do you think he is just ‘out for himself’? Does it matter whether he’s sincere if his actions lead to important reforms?10. Do you think you could survive in today’s world if you promised yourself that you would always act honorably? Do you think such a life is possible?Note: In order to do a good job on this assignment, you should easily have three to five pages (but it can be more). Be specific and elaborate on the answers to the above questions. Think! Writing Tip: Always assume that your audience knows nothing about the issue. A common mistake students make is leaving out critical information that they have learned, because they know that the instructor already knows the information. However, an instructor cannot give credit for knowledge that is absent from the essay. Your writing should be the evidence that you have the information, and have assimilated it into knowledge. REQUIREMENTS FOR PAPER:Written in MLA FormatWritten with Times New Roman 12 point font with NORMAL MARGINS!!!Double SpacedMinimum of three pagesYou must submit the finished paper through Canvas when you hit the NEXT button below. I will NOT accept an email version or hard copy. Submit it as required.Spell and grammar check your paper.  I strongly suggest having someone else ready your paper before submitting it to catch any last errors.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Hello . Im trying to make a argumentative essay on the story of battle royal By Ralph elliot . I only got 60% the first try . And I’m hopping i might get some help here . Under I will attach the objec

Delivering a high-quality product at a reasonable price is not enough anymore.

That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Using the rule of 72, approximate the following amounts. a. If the value of land in an area is increasing 6 percent a year, ho

  

Chapter #1

PROBLEMS (p. 24-25)

(Note: Some of these problems require the use of the Time Value of Money Tables in the Chapter 1 Appendix, pp. 40-43).

1. Using the rule of 72, approximate the following amounts.

a. If the value of land in an area is increasing 6 percent a year, how long will it take for property values to double?

 b. If you earn 10 percent on your investments, how long will it take for your money to double?

 c. At an annual interest rate of 5 percent, how long will it take for your savings to double?

  

2. In 2013, selected automobiles had an average cost of $16,000. The average cost of those same automobiles is now $20,000. What was the rate of increase for these automobiles between the two time periods?

3. A family spends $46,000 a year for living expenses. If prices increase by 3 percent a year for the next three years, what amount will the family need for their living expenses after three years?

  

4. Ben Collins plans to buy a house for $220,000. If that real estate is expected to increase in value by 2 percent each year, what will its approximate value be seven years from now?

  

5. What would be the yearly earnings for a person with $8,000 in savings at an annual interest rate of 1.5 percent?

  

6. Using time value of money tables (Exhibit 1-3 or Chapter Appendix tables-Pages 40-43), calculate the following:

a. The future value of $550 six years from now at 7 percent.

b. The future value of $700 saved each year for 10 years at 8 percent.

c. The amount that a person would have to deposit today (present value) at a 5 percent interest rate in order to have $1,000 five years from now.

d. The amount that a person would have to deposit today in order to be able to take out $500 a year for 10 years from an account earning 8 percent.

7. If you desire to have $10,000 for a down payment for a house in five years, what amount would you need to deposit today? Assume that your money will earn 4 percent.

8. Pete Morton is planning to go to graduate school in a program of study that will take three years. Pete wants to have $8,000 available each year for various school and living expenses. If he earns 3 percent on his money, how much must be deposit at the start of his studies to be able to withdraw $8,000 a year for three years?

9. Carla Lopez deposits $3,000 a year into her retirement account. If these funds have an average earning of 7 percent over the 40 years until her retirement, what will be the value of her retirement account?

10. If a person spends $10 a week on coffee (assume $500 a year), what would be the future value of that amount over ten years if the funds were deposited in an account earning 3 percent?

  

Chapter #2

PROBLEMS (p. 65-66)

1. Based on the following data, determine the amount of total assets, total liabilities, and net worth. 

Liquid assets, $3,870               Investment assets, $8,340

Current liabilities, $2,670          Household assets, $87,890 

Long-term liabilities, $76,230

  

a. Total assets 

b. Total liabilities

c. Net worth

2. Using the following balance sheet items and amounts, calculate the total liquid assets and total current liabilities: Money market account $2,600 Medical bills $262

Mortgage $158,000 Checking account $780

Retirement account $87,400 Credit card balance $489

a. Total liquid assets 

b. Total current liabilities 

 3. Use the following items to determine the total assets, total liabilities, net worth, total cash inflows, and total cash outflows.

Rent for the month, $650                             Monthly take-home salary, $2,185    

Spending for food, $345                               Cash in checking account, $450

Savings account balance, $1,890                 Balance of educational loan, $2,160 

Current value of automobile, $8,800             Telephone bill paid for month, $65 

Credit card balance, $235                             Loan payment, $80

Auto insurance, $230                                    Household possessions, $3,400

Video equipment, $2,350                              Payment for electricity, $90

Lunches/parking at work, $180                      Donations, $160

Personal computer, $1,200                            Value of stock investment, $860

Clothing purchase, $110                                Restaurant spending, $130

  

a. Total assets = 

b. Total liabilities = 

c. Net worth = 

a. Total cash inflows = 

e. Total cash outflows = 

  

4. For each of the following situations, compute the missing amount.

  

a. Assets $65,000; liabilities $18,000; net worth=??

  

b. Assets $86,500; liabilities=?? net worth $18,700.

  

c. Assets $34,280; liabilities $12,965; net worth=??

  

d. Assets=?? liabilities $38,345; net worth $52,654

5. Based on this financial data, calculate the ratios requested: (Page 51) Liabilities $7,800 Net worth $58,000

Liquid assets $4,600                           Current liabilities $1,300

Monthly credit payments $640            Take-home pay $2,575

Monthly savings $130                          Gross income $2,850

  

a. Debt ratio 

b. Current ratio

c. Debt-payments ratio 

d. Savings ratio

  

10. Fran Powers created the following budget and reported the actual spending listed. Calculate the variance for each of these categories, and indicate whether it was a deficit or a surplus.

     

Item                                    Budgeted          Actual       Variance        Deficit/Surplus

 

Food                                     $360                $298            

 

Transportation                       320                  334                         

 

Housing                                 950                  982    

 

Clothing                                  110                  134   

 

Personal                                 275                  231  

  

Note: A deficit in one category means that another category will have to make up the difference.

  

Chapter #3

PROBLEMS (p.100-101)

2. If Samantha Jones had the following itemized deductions, should she use Schedule A or the standard deduction? The standard deduction for her tax situation is $6,350.

Donations to church and other charities, $3,050

Medical and dental expenses exceeding 10 percent of adjusted gross income, $450 

State income tax, $920

Job-related expenses exceeding 2 percent of adjusted gross income, $1,450

3. What would be the average tax rate for a person who paid taxes of $6,435 on a taxable income of $40,780?

5. If $4,323 was withheld during the year and taxes owed were $4,122, would the person owe an additional amount or receive a refund? What is the amount?

9. Using the tax table in Exhibit 3–5, determine the amount of taxes for the following situations:

a. A head of household with taxable income of $62,525.

b. A single person with taxable income of $62,001.

c. A married person filing a separate return with taxable income of $62,365.

10. Wendy Brooks prepares her own income tax return each year. A tax preparer would charge her $75 for this service. Over a period of 10 years, how much does Wendy gain from preparing her own tax return? Assume she can earn 3 percent on her savings. (LO 3.3)

11. Julia Sims has $30,000 of adjusted gross income and $5,000 of medical expenses. She will be itemizing her tax deductions this year. The most recent tax year has a medical expenses floor of 10%. How much of a tax deduction will Julia be able to deduct?

  

***Tax Law Change: Medical and Dental expenses that can be itemized have changed over the years from 7.5% to 10%, back to 7.5% You will be told in all problems whether to use 7.5% or 10% for your calculations.

  

14. On December 30, you decide to make a $3,000 charitable donation. (LO 3.4)

a. If you are in the 28 percent tax bracket, how much will you save in taxes for the current year?

b. If you deposit that tax savings in a savings account for the next five years at 8 percent, what will be the future value of that account?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

IT Project This project simulates the Analysis and Planning needed to provide IT services for a new building. The student must

IT Project

This project simulates the Analysis and Planning needed to provide IT services for a new building. The student must submit a Project Schedule based on the Project Requirements and details below.

  1. Using the attached MS Word table template, create a project schedule. The project schedule will need the following columns: WBS; Task #; Task Action; Duration; Predecessor; and Resources.
  2. Do not go beyond the scope identified below. The project only covers tasks identified below.

Background: IT has been notified that a new office building is ready for occupancy. All telecommunication cables are in place. Rooms are equipped to provide access to the network once the network servers are installed. Wireless routers are installed throughout the building to provide wireless access once the network servers are installed. VOIP phones and vendor-supplied networked copier are already ordered.

NOTE: note specifications may contain multiple actions/tasks. Break them down into separate rows and group similar actions into a block of tasks (i.e., Purchase Resources; Setup Equipment; etc.).

Project Specifications:

• Purchase, setup, deploy and test network servers that will be managed in the new building’s IT area. o Setup includes loading and testing network software at corporate IT before deployment.
o Test network servers in the new building after deployment.
o NOTE: Network servers must be installed and operational before other devices can be tested

for internet and wireless connectivity.

  • Purchase, setup, deploy and test Desktop PCs and Laptops in offices, labs and administrative areas.
    o Setup includes loading and testing corporate software at corporate IT before deployment. o Test all systems and ensure they can access the network once deployed.
    o Test all wireless systems and ensure they can access the wireless routers.
  • Purchase, deploy and test wireless Projectors.
    o Test all Projectors to ensure desktops can access them via direct cabling. o Test all Project to ensure mobile laptops can access them wirelessly.
  • Purchase, deploy and test VOIP phones (they use the network to receive/generate phone calls). o Test all phones to ensure they function properly across the network.
  • Test networked Printers/Copiers once they are delivered by the lease vendor.
    o Test all printers/copiers to ensure they can print documents sent across the network.
    The COO has determined the following rules to facilitate occupancy:
  • IT Area must be ready first. Deploy and test network servers and desktop PC three weeks before any
    other location.
  • Administrative Areas must be ready second. Deploy and test their desktop PCs and VOIP phones one
    week before remaining locations.
    • Conference & Meeting Rooms must be ready third. Deploy and test their desktop PCs, VOIP
      phones and wireless projectors five days before the remaining locations.
    • Offices and labs are last. Deploy and test their desktop PCs, VOIP phones and wireless projectors

before occupancy.

Project Details: The new building includes the IT Area, Computer Labs, Administrative Areas, Individual Offices, a Conference Room, and a Public Meeting Room.

IT Area: resources include

  • 4 network servers
  • 1 desktop PC
  • 2 laptops
  • 2 VOIP phones
    Administrative Areas: 2 administrative areas will each have
  • 4 workstations, each with a desktop PC, networked via a network port
  • a VOIP phone for each of the 4 workstations
  • a vendor-supplied networked copier
    Conference Room. The conference room has
  • a wireless ceiling-mounted Projector
  • network connectivity via a network cable and a wireless access point
  • a VOIP phone
    Meeting Room. The meeting room has
  • a wireless ceiling-mounted Projector
  • 1 desktop PC with network connectivity via a network cable.
  • 2 VOIP phones (one near the lectern and the other wall mounted at the entrance
    Individual Offices: 40 offices will each have
  • a desktop PC networked via a network port
  • a VOIP phone
    Computer Labs: 2 computer labs will each have
  • a wireless ceiling-mounted Projector
  • a desktop PC, networked via a network port, and directly cabled to the Projector
  • 25 desktop PCs networked via a network port
  • a VOIP phone
  • a vendor-supplied networked copier
    Personnel Assignments
    PC Specialist (equipment purchase, software setup and PC support):
    o purchase, setup and installation of new laptops and desktop computers and corporate software o purchase of all projectors
    o work with Network Specialist to ensure network access is available on all computers and
    networked printers

Network Specialist (Telecomm support):
o setup and installation of network servers and all VOIP phones
o work with PC Specialist to ensure network access is available on all computers and networked

printers

AV Specialist (A/V requirements):
o Installation of all wireless projectors

o work with PC Specialist to ensure projectors can be accessed by appropriate computers

Take time to think about how the work of the Specialists will be conducted.

  • Understand how the occupancy rules affect the schedule timeline.
    o Since some locations are occupied at different times, handle the deployment and testing of resources for each location separately (i.e. IT Area separate from Admin Area; Conference Room, Meeting Room, etc.).
  • Make sure you satisfy all project specifications.
  • The PC Specialist, Network Specialist and AV Specialist can be completing tasks concurrently and it is quite
    possible that one specialist will have to wait while another specialist completes a task.

• The schedule must include a milestone for each block of tasks (Purchase Resources, Setup Equipment,

Deploy and Test).
o Each resource (network servers, computers, projectors) must be purchased separately since

they will come from different vendors. The VOIP phones and third-party network printers are

already ordered and just need to be tested once they arrive.
o Note: a single task may be used for a resource that is tested at a specific time (i.e. the testing of

all computers for administrative areas can be a single task; or the testing of all computer for the 2 computer labs can be a single task). However, a single task cannot be used when an action must be done during different occupancy periods (i.e., testing of IT Area resources is a separate task from testing of Administrative Areas, etc. since they take occupancy at different times.)

  • Task Actions must start with a verb and describe the action (i.e., Test VOIP phones) o Milestones do not start with verbs and have a zero duration.
  • When creating the schedule, use your best guess in determining Duration. Use a single measure (i.e., min.) for all tasks.
  • Resources must include both the people (title of the IT Specialist) and specific resource(s).
  • When creating Predecessors, point to the respective Task # (not the WBS number). It is not necessary
    to include a task that is already a predecessor of another task (i.e. consider the following tasks: 1: Order food, 2: Eat food, 3: Cleanup. The predecessor for 2 is 1. The predecessor for 3 is 2 (i.e. 2 already has a predecessor of 1).

o Note: be careful about predecessors. Not only are they directly related to the tasks that proceed them within a Milestone but they may be directly related to tasks within other Milestones (example: network servers must be operational before other equipment can be tested for network connectivity – look for other dependencies described above).

• The WBS should be completed once the schedule is in its final version.

Looking for good work without any plagiarism with separate JPG attachment in sync with attached template.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

travo importantly, they have responded to seniors’ desire to have access to a con- tinuum of services in familiar homelike sur

travo importantly, they have responded to seniors’ desire to have access to a con-

tinuum of services in familiar homelike surroundings. For residents in need of mini-

mal to moderate assistance, they have the option to pay privately for home healthcare

services within the privacy of their apartment. For those requiring more extensive as-

sistance, the vast majority of communities built in the last several years offer residents

on-site access to licensed assisted living. Some rental communities also offer special care

for residents with memory impairment, and the vast majority of entrance fee commu-

nities offer skilled nursing (Schless, 2007).

Quality of Life

Seniors also want the quality of their life to not only not decline when they move into

senior housing, but to actually improve. Many communities have responded by expand-b51106

ing their menu choices and hours of dining service and offering such service amenitiesebrary

as a wet bar, massage therapy, indoor swimming, a business center, banking services,

concierge services, a fitness center, and movie theater. The physical designs have been

adapted to accommodate seniors’ demands for more spaciously designed apartments,

greater choice of floor plans, and enhanced common areas that promote a more inti-

mate dining and social experience.

High Occupancy Rates

As a result, demand for senior housing is at a record high with occupancy levels run-

ning at more than 90 percent throughout most of the country. Current estimates of in-

dependent living capacity in the top 100 metro markets in the United States are

approximately 365,000 units. Over the next two decades, it is expected that inde-

pendent living capacity will need to increase by at least 50 percent in order to meet tu-

00871

ture demand (Schless, 2007). Projections for other forms of senior housing are similar.

eD

Summary

Senior housing is not all that well known as a segment of long-term care, but it has long

existed and is becoming much better recognized as a vital part of that system. It has

developed largely in response to the desire of today’s seniors for additional options

concerning where (and how) they live. It is also a good example of how the long-term

care system overlaps and interacts with other social systems in the overall continuum.

Senior Housing Case

Don and Rose have been married for more than half a century, and during that time, have

never been apart for more than a few days. Now, they are faced with the possibility of having to live apart for the remainder of their lives. But to intelligently discuss the cur-

rent situation, we must look at how it came to be.

Don, now 80, and Rose, now 71, have both been retired from active professional

lives and, until five years ago when Don suffered a stroke, their personal lives were ac-

tive as well. Upon giving up work, they moved to a continuing care retirement com-

munity (CCRC) in a southern state where they could take full advantage of the outdoors

that they both loved so much. The CCRC provided them with the social support they

sought, living among other seniors like themselves. They also traveled a lot and fully

enjoyed their hard-earned retirement. However, after the stroke, Don was unable to

do most of the things he had previously enjoyed. Rose, in part because she needed to

care for Don and in part because she didn’t want to do the things alone that they used

to do together, also stopped most activities. She spent virtually all of her time and en-

ergy being Don’s caregiver.

00e7142202457294f25572efdb51f06

However, it eventually became too much for her. Don, who once played football, brary

is nearly twice as large as Rose, making it very hard for her to help him with the activ-

ities of daily living (ADLs) such as bathing and dressing. To make matters worse, Rose

does not really like to drive the family car, because Don generally did all of the driving

when he was able to do so. Thus, she went out only when absolutely necessary.

As the caregiver burden became more and more difficult, Rose was able to get

some assistance from the CCRC. It began providing staff for an hour or two daily to

bathe and dress Don, delivered one meal each day, and a woman to come in and clean

the house on a weekly basis. Those services sufficed for a time, but it soon became

obvious that they were not enough. During the remainder of the day (and night) Rose

had to do it all by herself. Don was becoming increasingly distraught over his inabil-

ity to help Rose or even to take care of himself. Rose, on the other hand, was also be-

coming depressed and even found herself beginning to resent having to spend all of her

time caring for Don.

00871422 She began thinking, reluctantly, about placing Don in the nursing facility located

on the CCRC campus, but his medical requirements did not really require that level

of care. However, the CCRC also had an assisted living facility, which was just what

Don needed–at least at that point in time, and he was admitted. In addition to help-

ing Don with the ADLs he could not manage for himself (such as dressing, bathing,

and making sure he took his medication when needed), the facility provided Don with

supervision and with activities to keep him occupied that were designed to help him

gain back some of his independence.

Rose visited regularly, but her depression continued. She simply missed Don too

much. Her own health began to deteriorate as she neglected to eat properly and be-

came more and more withdrawn from outside activities.

One day a neighbor of Rose’s in the CCRC told her she should investigate the in-

dependent living apartments on the campus. After getting all of the necessary infor-

mation, these apartments seemed to be designed just for her, so Rose moved in. It

meant that she could more easily be close to Don and be part of his life. His need for supervision and assistance was still too great for him to live with her in her apartment,

but they were only a short distance apart.

She could visit Don and he could visit her. They even play bingo together, with

Rose helping Don to play. Rose no longer has to drive to see Don, and the facility pro-

vide transportation for shopping and other short trips.

This setting is just perfect for Rose and Don. His physical condition is not going

to improve markedly, but he is learning to be more independent. In addition, being near

him without the burden of being primary caregiver has lifted a load from Rose’s shoul-

ders. Perhaps most importantly, the assisted living facility is part of a larger, multi-

level complex. That means that as Don’s condition changes for the better or worse, he

can be moved to the appropriate unit without having to be transferred to another fa-

cility. Rose will still be close to him, and should her own health worsen, will be able

to get the services she needs as well.

00e714220245729412557c2efdb51f06

et

ra

Vocabulary Terms

The following terms are included in this chapter. They are important to the topics and is-

sues discussed herein and should become familiar to readers. Some of the terms are also

found in other chapters but may be used in different contexts. They may not be fully de-

fined herein. Thus, readers may wish to seek other, supplementary definitions of them.

Affinity groups

Age-restricted communities

Aging-in-place

Co-housing

Congregate housing

Continuing care accreditation

00e71422024 commission (CCAC)06

ebrarv

Continuing care retirement

community (CCRC)

Fee-for-service contract

Independent lifestyle

Independent living

Life care community

Life care/extensive contract

Lifetime contract

Modified/continuing care contract

Section 202 subsidized housing

Senior apartments

Senior housing

Service amenities

Supportive Housing for the

Elderly Program

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

You are the office manager for a real estate company in northern Utah  County. You tracked real estate listings, including cit

 

Exp19_Excel_Ch07_Cap_Real_Estate | Excel Chapter 7 Real Estate

 

Project Description:

You are the office manager for a real estate company in northern Utah  County. You tracked real estate listings, including city, agent,  listing price, sold price, etc. Agents can represent a seller, a buyer,  or both (known as dual agents). Your assistant prepared the spreadsheet  structure with agent names, agent types, the listing and sold prices,  and the listing and sold dates. You want to complete the spreadsheet by  calculating the number of days each house was on the market before being  sold, agent commissions, and bonuses. In addition, you will use  conditional functions to calculate summary statistics. For further  analysis, you will insert a map chart to indicate the average house  selling price by city. Finally, you will create a partial loan  amortization table and calculate cumulative interest and principal to  show a potential buyer to help the buyer make decisions.

The   spreadsheet contains codes (BA, DA, SA) to represent agent  roles (Buyer’s   Agent, Dual Agent,   Seller’s Agent). You want to  switch the codes for the actual descriptions.
  In cell E12 of the Details sheet, insert the SWITCH function to  evaluate the   agent code in cell D12. Include mixed cell references to  the codes and roles   in the range J2:K4 for the values
  and results arguments. use all cell references in the function. Copy the   function to the range E13:E39.
 

Now you want to calculate the   number of days between the list date and sale date.
 

  In cell J12, insert the DAYS function to calculate the number of  days between   the Listing Date and the Sale Date. Copy the function to  the range J13:J39.

You want to calculate agent   commissions based on their role.
 

  In cell K12, insert the IFS function to calculate the agent’s  commission   based on the agent code and the applicable rates in the  range L2:L4. Use   relative and mixed references correctly. Copy the  function to the range   K13:K39.
 

You want to calculate a bonus if   the sold price was at least equal  to the listing price, and if the house sold   within 30 days after being  listed.
 

  In cell L12, insert an IF function with a nested AND function to  calculate a   bonus. The AND function should ensure both conditions are  met: Sold Price   divided by the Listing Price is greater than or equal  to 100% (cell L7) and   the Days on Market are less than or equal to 30  (cell L8). If both conditions   are met, the bonus is $1,000 (cell L9).  Otherwise, the bonus is $0. Use mixed   cell references to the input  values in the range L7:L9. Copy the function to   the range L12:L39.

The top-left section of the   spreadsheet is designed for summary  statistics for one condition. You will   calculate average selling  prices and the number of houses sold in each city   (the condition).
 

  In cell B2, insert the AVERAGEIF function to calculate the average  Sold Price   for houses in the city of Alpine. Use mixed references for  the range; use a   relative reference to cell A2. Copy the function and  use the Paste Formulas   option to paste the function in the range B3:B5  so that the bottom border in   cell B5 is preserved.

You want to count the number of   houses in one city.
 

  In cell C2, insert the COUNTIF function to count the number of  houses in the   city of Alpine. Use mixed references for the range; and  use a relative   reference to cell A2. Copy the function and use the  Paste Formulas option to   paste the function in the range C3:C5 so that  the border in cell C5 is   preserved.

You want to calculate the total commissions   for each agent (the condition).
 

  In cell B7, insert the SUMIF function to total the commissions by  agent. Use   mixed references for the ranges; and use a relative  reference to cell A7.   Copy the function and use the Paste Formulas  option to paste the function in   the range B8:B9 so that the borders  are preserved.

The top-middle section of the   spreadsheet is designed for summary  statistics for multiple conditions. You   will calculate the number of  houses sold for each agent when he or she served   as a Dual Agent (DA).  Use mixed references for ranges and the agent code   condition in cell  J3. Use relative cell references to the agent condition in   cell E2.  When you copy the formulas, use the paste Formulas options to   preserve  border formatting.
 

  In cell F2, insert the COUNTIFS function in cell F2 to count the  number of   houses sold by the first agent (cell E2) who was a Dual  Agent (DA) (J3) for   that house. Use all cell references in the  function. Copy the function to the   range F3:F4 and preserve the bottom  border for cell F4.

You are ready to calculate the   total value of those houses for each  agent when he or she served as a Dual   Agent (DA). Use mixed  references for ranges and the agent code condition in   cell J3. Use  relative cell references to the agent condition in cell E2. When   you  copy the formulas, use the paste Formulas options to preserve border    formatting.
 

  In cell G2, insert the SUMIFS function to sum the selling prices of  the   houses sold by the first agent (cell E2) who was a Dual Agent  (DA) (J3) for   that house. Copy the function to the range G3:G4 and  preserve the bottom   border for cell G4.

Now, you will calculate the   highest-price house highest-price house  sold for each agent when he or she   served as a Dual Agent (DA). Use  mixed references for ranges and the agent   code condition in cell J3.  Use relative cell references to the agent   condition in cell E2. When  you copy the formulas, use the paste Formulas   options to preserve  border formatting.
 

  In cell H2, insert the MAXIFS function in cell H2 to display the  highest-price   house sold by the first agent (cell E2) who was a Dual  Agent (DA) (J3) for   that house. Copy the function to the range H3:H4  and preserve the borders in   the range H3:H4.

The Map worksheet contains a   list of cities, postal codes, and  average house sales. You will insert a map   chart to depict the  averages visually using the default gradient fill colors.
 

  Display the Map worksheet, select the range B1:C5 and insert a map chart.

Cut the map chart and paste it   in cell A7. Set a 2.31″ height and 3.62″ width.

You want to enter a meaningful   title for the map.
 

  Change the map title to Average Selling Price by Zip Code.

Display the Format Data Series   task pane, select the option to  display only regions with data, and show all   labels. Close the task  pane.

You are ready to start   completing the loan amortization table.
 

  Display the Loan worksheet. In cell B8, type a reference formula to  cell B1.   The balance before the first payment is identical to the  loan amount. Do not   type the value; use the cell reference instead. In  cell B9, subtract the   principal from the beginning balance on the  previous row. Copy the formula to   the range B10:B19.

Now, you will calculate the   interest for the first payment.
 

  In cell C8, calculate the interest for the first payment using the IPMT   function. Copy the function to the range C9:C19.

Next, you will calculate the   principal paid.
 

  In cell D8, calculate the principal paid for the first payment using the PPMT   function. Copy the
  function to the range D9:D19.

Rows 21-23 contain a summary   section for cumulative totals after the first year.
 

  In cell B22, insert the CUMIPMT function that calculates the  cumulative   interest after the first year. Use references to cells A8  and A19 for the   period arguments.

The next summary statistic will   calculate the principal paid after the first year.
 

  In cell B23, insert the CUMPRINC function that calculates the  cumulative   principal paid after the first year. Use references to  cells A8 and A19 for   the period arguments.

Rows 25-28 contain a section for   what-if analysis.
 

  In cell B27, use the RATE financial function to calculate the periodic rate   using $1,400 as the
  monthly payment (cell B26), the NPER, and loan amount in the original input   section.

In cell B28, calculate the APR   by multiplying the monthly rate (cell B27) by 12.

Create a footer with your name   on the left side, the sheet name  code in the center, and the file name code   on the right side of each  worksheet

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

A local business leader is looking for ways to promote change around personal and professional growth and learning for all mem

  

Steps to complete: PLEASE DO AS A PODCAST EXAMPLE BELOW

Scenario: A local business leader is looking for ways to promote change around personal and professional growth and learning for all members of the community. They have asked you to present your philosophy of change to the community—through a recorded presentation (or live, if in the classroom) or through a podcast they will air this month—to help demonstrate the value of employable skills and opportunities for positive change. The goal is to use examples from your personal experience to help listeners understand how they could begin to think about their own philosophy of change and how they navigate change in different contexts.

STEP 1: Introduce yourself to the audience and identify the goal of your presentation or podcast in a clear, concise manner. Your goal should be centered around how some or all of the 10 Skills and a philosophy of change have helped you—and can help others—exercise their problem solving skill (approximately 1 minute or less).

STEP 2: Since your audience will be unfamiliar with the 10 Skills and your philosophy of change, you should provide an overview (approximately 1–3 minutes total) that addresses the following:

  • What are the 10 Skills and why are      they important in your personal and professional life? (Note: You do not need to list and define each      skill, but you can speak of them broadly.)
  • What is a philosophy of change and      why is it important? How can it help you think about and solve problems in      your life?

STEP 3: Discuss your experience with the 10 Skills and your personal philosophy of change (approximately 3–5 minutes). Note: You may choose to talk about all 10 Skills or to focus on only a few.

You can discuss any or all of the options below:

  • How some or all of the 10 Skills      have informed your philosophy of change.
  • How some or all of the 10 Skills      can support you living out your personal philosophy of change.
  • How your personal philosophy of      change can support your continued development of some or all of the 10      Skills.

Remember, your audience will likely be unfamiliar with the 10 Skills and your philosophy of change. Your grade is based on how well you communicate the connection between this information in a way your audience will understand.

Your visual or audio presentation should be approximately 6–8 minutes long. Format for the presentation will vary (depending on selection), but overall the focus should be on speed of overall presentation, tempo of sections, volume (loud versus soft; distractions in certain parts), use of filler words or phrases, inclusion of an introduction and a conclusion, and sounds practiced versus read. Refer to Chapters 8 and 9 in your webtext to review professional presentation skills and tips on how to successfully communicate to a diverse audience. If you choose to do a podcast, refer to the examples in your webtext (Page 9.7) as a reference for formatting and style.

Example for Assignment – Script (Based on “Podcast Example A”)

OPENING 

My name is Ed Buchanan and I have traveled many different roads in nearly 40 years. From working in the professional world to working toward a degree, my experience points to one specific idea. INTRODUCTION

Today I will share my philosophy of change and how it is reinforced through experience working with employable skills. 

OVERVIEW – FIRST POINT 

“The way up and the way down are one and the same. Living and dead, waking and sleeping, young and old, are the same.” —Heraclitus, Life Is Flux, about 500 BC All of these comparisons have one thing in common: change. They are the same because they all involve a degree of change. If you do not look deeply, you may argue that there is no change happening in people who sleep or are dead, but that is not correct. Sleeping people breathe, cells heal, the brain functions and continues to work through the day’s problems. Even in death, we change. Some body functions may continue well after our deaths. We are not the same physical beings at the time of death as we are months or years afterward. Heraclitus believed that “the only constant is change” and that idea still drives people forward today. If we settle on this idea that change is the only constant, we can use this as the motivation to move forward. I can remember working at a major company in my 20s. It was a good job where I worked on electronics equipment. Translation: I played with broken stereos, TVs, cameras, and camcorders, and did my best to make sure they were working when I shipped them back to the customers. I was paid well—even though I had no real background in electronics repair—but I dedicated myself to learning. When a piece of equipment came in that I had never seen before, I sat down next to our senior technicians and watched as they took it apart, identified the problems, and corrected them. I was smart enough to recognize what I did not know and self-aware. The only way to improve was to find people who could show me the way and soak up everything I could. I did well. In fact, I did this so well that within a few short years I worked my way to the highest technician level and was moved around the shop to work wherever there was a heavy PHI201 © 2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of Strayer University. Page 4 of 5 workload. My agility made me a key team member and helped me pay my increasing school bills. I wouldn’t be where I am today if I had not used my skills and interacted with the change all around me. Going from unskilled to top tech level in a few short years is a good way to showcase how to address the changing world, but it’s not the only story. Dealing with change was at the heart of each moment in that journey. I had to change my knowledge level. I had to change my outlook and recognize where I needed to learn and who could teach me. I had to change the way my manager viewed me (beginning as unknowledgeable and becoming the go-to guy). Change, change, change. 

OVERVIEW – SECOND POINT 

What we will do now is talk about how each of you interacts with change. I have shared my outlook, mostly leaning on what Heraclitus said a long, long time ago. What do you know about change? How do you deal with it? More importantly, how will you deal with change next time you encounter it? [4:02] These are the basic questions I used to help think of the role change plays in my life. They conveniently will help you do the same. When I think through these questions, my mind goes right to recent experience with the 10 skills taught in Strayer gen ed courses—skills that employers are looking for because people that have these skills succeed. Communication. Problem solving. Agility. Self and social awareness. Technology. Initiative. Productivity. Results driven. Relationship building. Innovation. Like many people, I had different experience levels with different skills. Some of these skills, I came in with a really strong idea of what it meant. Other skills, I didn’t have quite the same grasp. What I did learn is that each of these skills developed over time. Stepping back, I realize that these all revolve around the same thing: change. 

KEY EXAMPLE

Agility is how well you can adapt to an ever-changing world. Innovation is looking at new ways to address barriers or ways of doing things. Problem solving is changing a situation to fix something that is going wrong. We started with an ancient philosopher, journeyed to the recent past and experience with the 10 skills, and now we move to the final part of my philosophy of change. PHI201 © 2020 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of Strayer University. Page 5 of 5 For most of us, change is not a light switch. We don’t just flip it and something inside of ourselves magically changes the world around us. The last part of my philosophy of change comes courtesy of Margaret Atwood. Many people will know her for the Hulu series The Handmaid’s Tale and this quote comes from her book of the same name: “Nothing changes instantaneously: in a gradually heating bathtub you’d be boiled to death before you knew it.” When the world around us gets more dangerous, we often do not recognize it. When the signs surround us that change is coming, we may not pay enough attention. What I encourage everyone to do, though, is to have a plan, or at least an idea, of how they want to respond to change and the person they need to be when change pops up in your life. 

CLOSING

Change surrounds each of us—at home, at work, at school, sometimes just driving home after a long day. If we have a philosophy about how we deal with change, it can take a little of the sting out of change and make change something you actually look for in your life. I cannot tell you what change is coming. What I can say is you have two options: be ready or ignore it. Only one of these options will pay off.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

You are given the following information regarding prices for stocks of the following firms:    Price   Stock Number of   shar

   

FIN 435 – Problem set (Mid 1)

Chapter 2

1. You are given the following information regarding prices for stocks of the following firms:

  

Price

 

Stock

Number of   shares

T

T+1

 

Beximco

1,000,000

60

80

 

BATBC

10,000,000

20

35

 

Bank Asia

30,000,000

18

25

a. Construct a price-weighted index for these three stocks, and compute the percentage change in the series for the period from T to T + 1. Assume a starting index value of 10,000 points.

b. Construct a value-weighted index for these three stocks, and compute the percentage change in the series for the period from T to T + 1. Assume a starting index value of 10,000 points.

c. Briefly discuss the difference in the results for the two stock indexes.

2. Based on the following stock price and shares outstanding information, compute the beginning and ending values for a price-weighted index and a market-value-weighted index. Assume that the value-weighted index had a base value of 100 points.

  

December 31, 2016

December 31, 2017

 

Stock

Price

Shares outstanding

Price

Shares outstanding

 

Beximco

20

100,000,000

32

100,000,000

 

BATBC

80

2,000,000

45

4,000,000

 

Bank Asia

40

25,000,000

42

25,000,000

a. Compute the percentage change in the value of each index.

b. Explain the difference in results between the two indexes.

Page 1 of 11

   

Use the following table for questions 3 to 12.

  

Jan. 13, 2017

Stock Price X Y Z

20 40 30

# Shares

X Y Z 

1000 2000 1000*

 

Jan. 14, 2017

25

42

18

1000

2000

2000

 

Jan. 15, 2017

27

45

8

1000**

2000

2000

 

Jan. 16, 2017

20

40

10

3000

2000

2000

*2:1 Split on Stock Z after Close on Jan. 13, 2017

**3:1 Split on Stock X after Close on Jan. 15, 2017

The base date for index calculations is January 13, 2017

3. Calculate a price weighted average for January 13th. A. 32 B. 30

C. 36.13 D. 34

4. What is the divisor at the beginning of January 14th? A. 3.0 B. 2.5

C. 2.2734 D. 1.9375

5. Calculate a price weighted average for January 14th. A. 32 B. 30

C. 36.13 D. 34

6. Calculate a price weighed average for January 15th.

A. 30 B. 36.13

C. 32 D. 34

7. What is the divisor at the beginning of January 16th? A. 1.9375 B. 3.0

C. 2.5 D. 2.2734

8. Calculate a price weighted average for January 16th. A. 30 B. 32

C. 34 D. 36.13

9. Calculate a value weighted index for Jan. 13th if the initial index value is 100. A. 111.54 B. 100

C. 102.31 D. 123.07

10. Calculate a value weighted index for Jan. 14th if the initial index value is 100. A. 100 B. 102.31

C. 123.07 D. 111.54

11. Calculate a value weighted index for January 15th if the initial index value is 100. A. 102.31 B. 100

C. 123.07 D. 111.54

12. Calculate a value weighted index for January 16th if the initial index value is 100. A. 123.07 B. 100.00

C. 102.31 D. 111.54

Page 2 of 11

   

Chapter 3

1. Assume you purchased 200 shares of ENVOYTEX common stock on margin at BDT 70 per share from your broker. If the initial margin is 55%, how much did you borrow from the broker?

2. You want to purchase OLYMPIC stock at BDT 40 from your broker using as little of your own money as possible. If initial margin is 50% and you have BDT 4000 to invest, how many shares can you buy?

3. Assume you sell short 100 shares of common stock at BDT 45 per share, with initial margin at 50%. The stock paid no dividends during the period, and you did not remove any money from the account before making the offsetting transaction. What would be your rate of return if you covered the short sale at BDT 40/share?

4. You purchased 100 shares of GLAXOSMITH common stock on margin at BDT 70 per share. Assume the initial margin is 50% and the maintenance margin is 30%. Assume the stock pays no dividend; ignore interest on margin. Below what stock price level would you get a margin call?

5. You sold short 100 shares of common stock at BDT 45 per share. The initial margin is 50%. At what stock price would you receive a margin call if the maintenance margin is 35%?

6. Mofiz opens a brokerage account and purchases 300 shares of Hafiz Corporation at BDT 40 per share. He borrows BDT 4,000 from his broker to help pay for the purchase. The interest rate on the loan is 8%.

a. If the share price falls to BDT 30 per share by the end of the year, what is the remaining margin in his account? If the maintenance margin requirement is 30%, will he receive a margin call?

b. What is the rate of return on his investment?

7. You are bullish on ABC stock. The current market price is BDT 50 per share, and you have BDT 5,000 of your own to invest. You borrow an additional BDT 5,000 from your broker at an interest rate of 8% per year and invest BDT 10,000 in the stock.

a. What will be your rate of return if the price of ABC stock goes up by 10% during the next year? The stock currently pays no dividends.

b. How far does the price of ABC stock have to fall for you to get a margin call if the maintenance margin is 30%? Assume the price fall happens immediately.

8. Sabrina has a margin account with a balance of BDT 150,000. If the initial margin deposit is 60 percent and Apex Industries is currently selling at BDT 50 per share.

a. How many shares of Apex can Sabrina purchase?

b. What is Sabrina’s profit/loss if Apex’s price after one year is BDT 40?

c. If the maintenance margin is 25 percent, to what price can Apex Industries fall before Sabrina receives a margin call?

Page 3 of 11

   

9. Hiya has a margin account with a balance of BDT 50,000. If the initial margin deposit is 50 percent, and Reliance Industries is currently selling at BDT 50 per share.

a. How many shares of Reliance can Hiya buy?

b. What is Hiya’s profit if Reliance’s price rises to BDT 80?

c. If the maintenance margin is 25 percent, to what price can Reliance Industries stock price fall before Hiya receives a margin call?

10. Sarah has a margin account with a balance of BDT 60,000. If initial margin requirements are 80 percent, and BD Lamps is currently selling at BDT 40 per share.

a. How many shares of BD Lamps can Sarah buy?

b. What is Sarah’s profit if BD Lamp’s price rises to BDT 50?

c. If the maintenance margin is 25 percent, to what price can BD Lamps fall before Sarah receives a margin call?

11. You decide to sell 100 shares of Beximco Industries short when it is selling at its yearly high of BDT 35. Your broker tells you that your margin requirement is 55 percent and that the commission on the sale is BDT 15. While you are short, Beximco pays a BDT 0.75 per share dividend. At the end of one year you buy your Beximco shares (cover your short sale) at BDT 30 and are charged a commission of BDT 15 and a 6 percent interest rate.

a. What is your dollar return on the investment?

b. What is your rate of return on the investment?

12. You decide to sell 100 shares of Tareq Enterprises Inc. short when it is selling at its yearly high of BDT 42.25. Your broker tells you that your margin requirement is 60 percent and that the commission on the sale is BDT 20. While you are short, Tareq pays a BDT 0.85 per share dividend. At the end of one year you buy your Tareq shares (cover your short sale) at BDT 44 and are charged a commission of BDT 20 and a 5 percent interest rate.

a. What is your dollar return on the investment?

b. What is your rate of return on the investment?

13. Suppose you buy a round lot of DS Solutions stock on 60% margin when it is selling at BDT 55 a share. The broker charges a 10 percent annual interest rate and commissions are 3 percent of the total stock value on both the purchase and the sale. If at year end you receive a BDT 1.10 per share dividend and sell the stock for 55 5/8, what is your rate of return on the investment?

14. Suppose you buy a round lot of GD Inc. stock on 55% margin when it is selling at BDT 40 a share. The broker charges a 10 percent annual interest rate and commissions are 4 percent of the total stock value on both the purchase and the sale. If at year end you receive a BDT 0.90 per share dividend and sell the stock for 35 5/8, what is your rate of return on the investment?

15. Suppose you buy a round lot of Altaf Industries stock on 50% margin when it is selling at BDT 35 a share. The broker charges a 10 percent annual interest rate and commissions are 5 percent of the total stock value on both the purchase and the sale. If at year end you receive a BDT 1.00 per share dividend and sell the stock for BDT 42.63, what is your rate of return on the investment?

Page 4 of 11

   

16. You decide to sell short 200 shares of Prime Bank stock at a price of BDT 75. Your margin deposit is 65 percent. Commission on the sale is 1.25%. While you are short, the stock pays a BDT 1.75 per share dividend. Interest on margin debt is 5.25% per year.

a. At the end of one year you close out your short position by purchasing share of Prime Bank at BDT 45 per share. The commission is 1.25%. What is your rate of return on the investment?

b. Suppose at the end of one year Prime Bank is selling at BDT 90 per share and you cover your short position at this price. What is your rate of return on the investment? (Assume a 1.25% commission on the purchase)

17. Shares of Square stock are selling for BDT 45 per share. Brokerage commissions are 2% for purchases and 2% for sales. The interest rate on margin debt is 6.25% per year. The maintenance margin is 30%.

a. At the end of one year shares of Square stock are selling for BDT 55 per share and the company paid dividends of BDT 0.85 per share. Assuming that you paid the full cost of the purchase, what is your rate of return if you sell Square stock?

b. At the end of one year shares of Square stock are selling for BDT 35 per share and the company paid dividends of BDT 0.85 per share. Assuming that you paid the full cost of the purchase, what is your rate of return if you sell Square stock?

c. At the end of one year shares of Square stock are selling for BDT 55 per share and the company paid dividends of BDT 0.85 per share. Assuming that you borrowed 25% of cost of the purchase, what is your rate of return?

d. At the end of one year shares of Square stock are selling for BDT 35 per share and the company paid dividends of BDT 0.85 per share. Assuming that you borrowed 25% of cost of the purchase, what is your rate of return?

e. Assume that you purchase 150 shares of Square stock at BDT 45 each by making a margin deposit of 55%. At what price would you receive a margin call?

18. The stock of the Prime Bank is selling for BDT 28 a share. You put in a limit buy order at BDT 24 for one month. During the month, the stock price declines to BDT 20, then jumps to BDT 36. Ignoring commissions, what would have been your rate of return on this investment? What would be your rate of return if you had put in a market order? What if your limit order was at BDT 18?

19. You decide to sell short 100 shares of Square Pharma when it is selling at its yearly high of 56. Your broker tells you that your margin requirement is 45 percent and that the commission on the purchase is BDT 155. While you are short the stock, Charlotte pays a BDT 2.50 per share dividend. At the end of one year, you buy 100 shares of Square Pharma at 45 to close out your position and are charged a commission of BDT 145 and 8 percent interest on the money borrowed. What is your rate of return on the investment?

20. Suppose you buy a round lot of Zodiac Industries stock on 55 percent margin when the stock is selling at BDT 20 a share. The broker charges a 10 percent annual interest rate, and commissions are 3 percent of the total stock value on both the purchase and sale. A year later, you receive a BDT 0.50 per share dividend and sell the stock for 27. What is your rate of return on the investment?

Page 5 of 11

  

Chapter 5

1. You purchased a share of stock for BDT 20. One year later you received BDT 1 as a dividend and sold the share for BDT 29. What was your holding-period return?

2. You have been given this probability distribution for the holding-period return for ABC stock.

  

State of the economy

Probability

HPR

 

Boom

0.30

18%

 

Normal growth

0.50

12%

 

Recession

0.20

-5%

a) What is the expected holding-period return for ABC stock?

b) What is the expected standard deviation for ABC stock?

c) What is the expected variance for ABC stock?

3. If a portfolio had a return of 12%, the risk free asset return was 4%, and the standard deviation of the portfolio’s excess returns was 25%, what would be the risk premium?

4. You purchase a share of ACI stock for BDT 90. One year later, after receiving a dividend of BDT 3, you sell the stock for BDT 92. What was your holding-period return?

5. If a portfolio had a return of 15%, the risk free asset return was 5%, and the standard deviation of the portfolio’s excess returns was 30%, what would be the Sharpe ratio?

6. You purchased a share of stock for BDT 30. One year later you received BDT 1.50 as a dividend and sold the share for BDT 32.25. What was your holding-period return?

7. BATBC stock has the following probability distribution of expected prices one year from now:

  

State of   the economy

Probability

Price

 

1

25%

BDT 50

 

2

40%

BDT 60

 

3

35%

BDT 70

If you buy BATBC today for BDT 55 and it will pay a dividend during the year of BDT 4 per share, what is your expected holding-period return on BATBC?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"