Real Estate Investment Analysis

You have been hired to perform an investment analysis for a high net worth individual to determine if they should purchase a commercial real estate investment. The investment includes office, retail and townhome land.

The following are the income characteristics:

Office Ú 50,000 square feet is leased to a national tenant, Funeral Directors Association for $40 per square foot for the next 20 years. The rent will not increase, and there are expense stops of $8.50 per square foot and there is no risk of vacancy or credit loss. 20,000 square feet is leased to anaccounting firm, Dewey Cheatham, and Howe for $36 per square foot for the next three years with no rent increases andthere is no risk of vacancy or credit loss. At the end of three years, they will vacate the space and it will take six months to lease the space at which time the market rent is projected to be $40 per square foot with annual increases of 2 percent. The lease term for this space is 15 years and the vacancy and credit loss on this space is 1 percent. Office expenses for all tenants are $7.25 per square foot and increase by 3 percent per year.

Retail Ú 15,000 square feet is leased to Trader JoeÈs for $45 per square foot with no rent increases on a triple net basis for the next 20 years, and there is norisk of default. They pay percentage rent of 2.5 percent over the natural breakpoint. They currently have annual store sales of $20 million and expect sales to grow by 8 percent per year. 30,000 square feet is leased to HH Gregg for $35 per square foot triple net basis for the next 15 years with no rent increases. However, percentage rent is 4 percent over the natural breakpoint. Current store sales are $24 million and are expected to grow by 10 percent per year. Caribou Coffee leases 1,200 square feet for $50 per square foot with rent increases of 4 percent per year on a triple net basis for 15 years,and there is no risk of credit loss.

Townhome Land Ú There is acreage to support 120 townhomes. These lots are under contract to three different builders: Eagle of Virginia, Ryan Homes, and HHHunt. Each builder will take down (purchase) 10 lots per year at an initial price of $75,000 and lot prices will increase by $10,000 per year until all lots are sold. The development cost of each lot is $30,000 and will increase by $5,000 per year. Holding costs are $1,000 based on the remaining lots, and the cost of sale for each lot is 6 percent.
Financing ÚThird Fifth Bank is providing 70 percent loan to value at 6.75 percent amortized over 25 years with a 10 year callon the office and retail area only. No financing is available on the land.
Taxes Ú Your investor has an ordinary income tax rate of 28 percent. The long term capital gain taxes are 20 percent, and recapture is 25 percent.

Investment Criteria/AssumptionsÚThe property is offered for $45 million. The terminal cap rate is 7.50percent, and the discount rate is 9.5 percent. The holding period is 10 years. Assume that the mixed use land value is $10 million.Also, assume that the cost of sale at the end of the holding period is 1 percent.


What are the annual cash flows for periods 1 to 11; what is the terminal value; what is the before and after tax NPV and IRR (use end of period); what is the division of value between cash flows and resale? Do you recommend purchasing the property? Explain why or why not. Show all calculations Ú PGI, EGI, Expenses, NOI, Taxes, etc. If unclear about something, clearly state your assumptions.

Unit V Scholarly Activity

Data Warehouses and Data Marts

Write a one- to two-page (250-500 word) paper that discusses the differences between data warehouses and data marts. Also, discuss how organizations can use data warehouses and data marts to acquire data. You must use the CSU Online Library to locate at least two sources for your paper.

APA rules for formatting, quoting, paraphrasing, citing, and listing of sources are to be followed.

Cost management: short-term vs. long-term) Flatland Metals Co. produces steel products for a variety of customers. One division of the company is Residential Products Division, created in the late 1940s. Since that time, this divisionÈs principal products
has been continuously profitable since 1950, and in 1996, it generated profits of $10 million on sales of $300 million. However, over the past ten years, growth in the division has been slow; profitability has become stagnant, and few new products have been developed, although the garage door components market has matured. The president of the company, John Stamp, has asked his senior staff to evaluate the operations of the Residential Products Division and to make recommendations for changes that would improve its operations. The staff uncovered the following facts:
òTracinda Green, age 53, has been president of the division for the past fifteen years.
òGreen receives a compensation package that includes a salary of $175,000 annually plus a cash bonus based on achievement of the budgeted level of annual profit.
òGrowth in sales in the residential metal products industry has averaged 12 percent annually over the past decade. Most of the growth has occurred in ornamental products used in residential privacy fencing.
òNationally, the divisionÈs market share in the overall residential metal products industry has dropped from 12 percent to 7 percent during the past ten years and has dropped from 40 percent to 25 percent for garage door components.
òThe division maintains its own information systems. The systems in use today are mostly the same systems that were in place fifteen years ago; however, some of the manual systems have been computerized (e.g., payroll, accounts payable, accounting).
òThe division has no customer service department. A small sales staff solicits and takes orders by phone from national distribution chains.
òThe major intra-division communication tool is the annual operating budget. No formal statements have been prepared in the division regarding strategies, mission, values, goals and objectives, or identifying core competencies.Given the introductory paragraphs and the facts from the staff of the companyÈs president, identify the major problems in the Residential Products Division and develop recommendations to address the problems you have identified

You deposited $160,000 into an education savings plan, hoping to have $420,000 available 12 years later when your first child starts university. However, you did not invest very well, and two years later, the accountÈs balance has dropped to $140,000. Let us look at what you need to do to get the savings plan back on track.
a. What was the original annual rate of return needed to reach your goal when you started the fund two years ago?
b. With only $140,000 in the fund and 10 years remaining until your first child starts university, what annual rate of return would the fund have to make for you to reach your $420,000 goal if you add nothing to the account?
c. Shocked by your experience of the past two years, you feel the education savings fund has invested too much in shares, and you want a low-risk fund in order to ensure you have the necessary $420,000 in 10 years. You are willing to make end-of-the-month deposits to the fund as well. You find you can get a fund that promises to pay a guaranteed annual return of 6% that is compounded monthly. You decide to transfer the $140,000 to this new fund and make the necessary monthly deposits. How large a monthly deposit must you make into this new fund each month to obtain the $420,000 required at the end of 10 years? (6 marks)
d. After seeing how large the monthly deposit would be (in part (c) of this question), you decide to invest the $140,000 today and $500 at the end of each month for the next 10 years into a fund comprising 50% shares and 50% bonds and hope for the best. What Annual Percentage Rate (APR) would the fund have to earn in order to reach your $420,000 goal?

Table 1: Number of cells observed in each stage of the cell cycle(2 pts)
Predicted %
Number of cells in stage
Total number

of cells counted*
Calculated %












NOTE: You do not have to draw the cells in each of the stages.

Questions (6 pts)

What stage of the cell cycle (not just mitosis) were most of the onion root tip cells in? Does this make sense? Why? Cite source(s) used.

What is the function of mitosis in a cell that is about to divide? Cite source(s) used.

How accurate were your time predictions, based on your data, for each stage of the cell cycle?

Lab 12 Experiment 1: Meiosis

Read through the Lab 12 Introduction material and the instructions for the Lab 12 Experiment 1. Pay attention to the added information under the Week 4 Experiment link regarding these experiments! In the table below, describe the major events that take place in each stage of Meiosis and indicate the number of chromosomes in each. Cite your sources!(14pts)

Major Events
# of Chromosomes in each cell
Meiosis I

Prophase I
Nuclear membrane breaks down and chromosomes condense. Two sets of homologous chromosomes are attached at the centromere. Crossing over will occur between the homologous pairs.
Metaphase I

Anaphase I

Telophase I

Meiosis II

Prophase II

Metaphase II

Anaphase II

Telophase II

Sources used:

Questions(12 pts)

Name at least two differences between Meiosis I and Meiosis II in terms of what is produced and what occurs with the chromosomes. Cite source(s) used.

Name and briefly describe two processes that occur during meiosis that contribute to genetic variation. Cite source(s) used.

At the beginning of meiosis I are the cells diploid or haploid?

What are they at the beginning of meiosis II?

Why is it necessary to reduce the chromosome number of gametes (egg and sperm), but not other cells of an organism? Cite source(s) used.

If humans have 46 chromosomes in each of their body cells, determine how many chromosomes you would expect to find in the following cells:

Sperm _______________
Egg _________________
Daughter cell from mitosis __________
Daughter cell from Meiosis II __________

Investigate one of the diseasesfrom the following list.Include the following:
Name of the disease or disorder
What is the type of mutation and when might it occur?
What chromosome is affected?
What are the consequences?
What is the incidence rate of this disease or disorder?

Down Syndrome Turner Syndrome Klinefelter Syndrome
Jacobs Syndrome Triple X Edward Syndrome
Patau Syndrome Hemophilia Cri-du-chat Syndrome
Cystic fibrosis Prader-Willis Syndrome Fragile X

Remember to properly cite your sources! (Minimum of 250 words) (6 pt)

L211 Homework 4 Spring 2016 1 TOt First Name:______________________Last Name:_____________________________________ IU User Name: _________________________________ Due In class: Thursday April 28 th (or before) F Please staple/clip. We will not be responsible for lost pages. ************** PART I ôDecoding the genetics of Languageõ A complex series of face and mouth movements are necessary for speaking fluently. In a threegeneration pedigree of a British family (known as KE Family) half of the family members have difficulties with grammar, comprehension and speech- termed speech language disorder. The underlying disorder is termed ôChildhood Apraxiaõ, a result of the failure to co-ordinate muscle movements of mouth and face that are needed for speech. It is an autosomal dominant disorder with affected individuals being heterozygous for the gene in question. Q1. Based on the information above how many copies of a mutated gene will an individual need to inherit to confer the
trait? [1pt] In 2001, geneticists identified the cause of the inherited speech deficit in members of this family and attributed it to a mutation within a single gene FOXP2. (Cecilia S. L. Lai, Simon E. Fisher, Jane A. Hurst, Faraneh Vargha-Khadem and Anthony P. Monaco; Nature 413, 519-523(4 October 2001) This was exciting news as no ÀgeneÈ had ever been associated with a complex trait such as language. Turns out, FOXP2 is a transcription factor belonging to the winged helix transcription factor family characterized by a highly conserved Forkhead (Fox) domain that binds to distinct DNA sequences in its target gene’s regulatory regions. The mutation within the affected members of the family lies in a single point mutation such that G-A transition changes the amino acid from R553H (R at the 553 position to H) affecting itÈs ability to bind to DNA. Q2. FOXP2 is expressed (the protein is found) in many tissues, during development including parts of the brain, the lung, the gu
t and the heart. Yet, members of the KE family only seem to show deficits confined to regions of the brain implicated in speech development that manifests as speech apraxia. L211 Homework 4 Spring 2016 2 TOt Give one possible explanation for why that may be keeping in mind the nature of the inheritance [2pts] Q3. A lot more research has been done on FOXP2, including the amazing finding that FOXP2 is not unique to humans. In fact, the gene evolved early and is found in a diverse array of animal species- birds, bats and bees. The human FOXP2 differs from our closest relatives the chimpanzees, gorillas and rhesus macaques by just 2 amino acids and from that found in mice by only 3 amino acids! What this tells us is that through evolution a few amino acids (only 2 infact) provided some advantage to the way language evolved and possibly the difference between the Àuniquely humanÈ ability of complex language and the rest of the animal kingdom. [1 pts] Based on this information a
lone which of the following makes sense: A. If a mouse FoxP2 gene is removed, the mouse might ôtalk.õ B. Feeding mice the three amino acids that differ between human and mouse might enable the mice to ôtalk.õ C. Replacing the mutated human FOXP2 gene with a mouse FoxP2 gene is a way to cure speech disorders. D. Putting the human version of FOXP2 gene into a mouse might enable it to form more complex sounds similar to human language L211 Homework 4 Spring 2016 3 TOt Q4. Clearly genetically mutations in FOXP2 lead to problems with speech in the KE family. Researchers are interested in understanding how? Some insight can be gained into this question by learning more about what the normal function of FOXP2 is. Describe an experiment you would do to attempt to answer the question : ô What genes are regulated by FOXP2 in the brainõ [4pts] Assume you have all the possible cell lines you need. L211 Homework 4 Spring 2016 4 TOt Part II Developmental Patterning in Drosophila Exp
ression of the Even-skipped (Eve) gene in early Drosophila embryos is under the control of several transcription regulators. In one example, one of the Eve stripes is positioned near the anterior region of the embryo, and its regulatory module contains binding sites for Bicoid and Hunchback (activators) as well as Giant and Krⁿppel (inhibitors) such that the gene is expressed only in the region where concentrations of the two activators are high and the concentrations of the two inhibitors are low. A reporter gene can be placed under the control of this module, and it can be shown to form a stripe in the same place in the embryo as the corresponding stripe of Eve. Answer the following question(s) based on these findings. Q1. In the following schematic diagrams of an early Drosophila embryo, in which region would you expect to find the reporter protein put under the control of the regulatory module mentioned above? 1pt Circle or write the correct region number: Bicoid 1 Hun
chback Giant Krⁿppel 2 3 4 5 6 7 L211 Homework 4 Spring 2016 5 TOt Q2. What would you expect to happen to the pattern of reporter expression in flies that lack the gene encoding Giant? [2] A. It would be expressed in all seven stripes. B. It would be expressed in stripe 5 only. C. It would expand to cover a broad anterior region of the embryo. D. It would fail to express efficiently in the stripe 2 region. E. It would be expressed throughout the whole embryo. Q3. What would you expect to happen to the pattern of reporter expression in flies that lack the gene encoding Bicoid? [2] A. It would be expressed in all seven stripes. B. It would be expressed in stripe 5 only. C. It would expand to cover a broad anterior region of the embryo. D. It would fail to express efficiently in the stripe 2 region. E. It would be expressed throughout the whole embryo. PART III Revision [1 pt each] 1. Which of the following organisms has a circular chromosome and therefore does not require DN
A telomerase to finish chromosome replication? A. Bacteria B. Yeast C. Drosophila D. Mouse 2. The base ôuracilõ combines with a sugar and three phosphates to form uridine 5È- triphosphate. Which sugar is incorporated into UTP? A. 2È-deoxypentose B. 2È-deoxyribose C. 3È-deoxyribose D. ribose 3. Which of the following elements controls the spatial (where) and temporal (when) expression pattern of an individual gene? A. Enhancer B. Core promoter C. 5` and 3` UTRs D. Intron 4. Which of the following choices is NOT required for DNA synthesis to occur in vitro? A. ADP B. nucleotides L211 Homework 4 Spring 2016 6 TOt C. DNA template D. DNA polymerase 5. Different types of RNA are known to function in the cell. Which of the following choices is an adaptor molecule that links the template (that encodes the protein) to the growing polypeptide chain? A. mRNA B. tRNA C. rRNA D. none of the above are adaptor molecules 6. Upon which of the following choices can DNA polymerase use to
start replicating DNA? A. an RNA:DNA primer:template junction B. a DNA:DNA primer:template junction C. single-stranded DNA D. a. or b. 7. What would be the sequence of the partner strand of DNA shown below. (The strand that makes up the other half to make a dsDNA helix) Write your sequence in the 5È-3È orientation here: ________________________________ P a r t n e r s t r a n d L211 Homework 4 Spring 2016 7 TOt 8. Which of the following characteristics of DNA-dependent DNA synthesis is not the same for DNA-dependent RNA synthesis? A. Synthesis requires a template. B. Initiation involves the recognition of a specific DNA sequence. C. Initiation of synthesis requires a primer. D. Synthesis is catalyzed in the 5′ to 3′ direction. E. All of the choices given are the same for both DNA and RNA synthesis. Fill in the blanks with the appropriate scientific terminology: [0.5 per blank] The instructions specified by the DNA will ultimately specify the sequence of proteins. This pro
cess involves DNA, made up of [number] ___________________different nucleotides, which gets ___________________________ into RNA, which is then ________________________into proteins, made up of [number] _______________ different amino acids. In eukaryotic cells, DNA gets made into RNA in the _________________, while proteins are produced from RNA in the _________________. The segment of DNA called a ______________________ is the portion that is copied into RNA; this process is catalyzed by __________________________.

Choose one of the court cases described in the text or use the Internet to research a court case that specifically addresses parental rights or due process.
Write an essay of 1,250-1,500-words analyzing the case, responding to the following questions:
Who were the parties involved?
What issues brought this case to court?
What were the main points of disagreement?
When and how was the case adjudicated?
What were the final outcomes?
Do you agree or disagree with the outcome? Explain.
Prepare this assignment according to the APA guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required.

This week, you will describe the program and identify the right division for the program.
In a Microsoft Word document, create a 2- to 3-page report covering the following:
Develop the purpose of your proposed program to address the growing rate of diabetes. Be sure to develop a purpose that is consistent with one of the core functions of public health and includes at least one of the ten essential functions of public health.
Develop at least two, and no more than five, key objectives of the program. The objectives should be measureable and time bound.
Describe the key components or activities of your proposed program; for example, health education materials or screening.
Identify the division or department that should house the new program. Justify your choice.
Explain the proposed services of the new program.
Support your responses with appropriate research, scholarly references, and specific examples.
Cite all sources in APA format.

Paper details:

Please, answer the three following questions. Be aware from any grammar error, punctuation, etc. Write the answers in your own words and be clear. I uploaded the chapter. Please read the chapter and answer the questions.
1) Why did Japan succeed at modernizing while China did not? In your analysis, what was the most important reason that Japan succeeded at modernizing while China did not?

2) What factors make people turn to solutions during times of extreme stress that they wouldnÈt consider otherwise? Do you see current examples of this phenomena? What stresses in these modern societies do you think are provoking such movements?

3) To what extent did Japan actually modernize?

Paper details:

DNA integrity related to conception
To break down to series of 2-3 question for 3 year study.
Does outcome of DNA integrity can be used to help to predict successful ART