Personal Budget At the beginning of the school year, Katherine Malloy decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer job) $7,990 Purchase season football tickets in September 110 Additional entertainment for each month 280 Pay fall semester tuition in September 4,300 Pay rent at the beginning of each month 390 Pay for food each month 220 Pay apartment deposit on September 2 (to be returned December 15) 600 Part-time job earnings each month (net of taxes) 990 a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except an overall cash decrease which should be indicated with a minus sign.

b. Are the four monthly budgets that are presented prepared as static budgets or flexible budgets?

c. Malloy can see that her present plan ------------ sufficient cash. If Malloy did not budget but went ahead with the original plan, she would be $---------- ----------- at the end of December, with no time left to adjust.

What is the present value of a $15 million pool of 30-year mortgages with an 10.5 percent per year monthly mortgage coupon if market rates are 7 percent? The GNMA guarantee fee is 7 basis points and the FI servicing fee is 43 basis points.

a. Assume that the GNMA pass-through is fully amortized.
b. Assume that the GNMA pass-through is only half amortized. Market rates are still 7 percent. If there is a lump sum payment at the maturity of the GNMA pass-through that equals 60 percent of the mortgage pool's face value, find the present value of the pass-through.

PLEASE PROVIDE EXCEL FORMULA SPELLED OUT TO ANSWER THESE PROBLEMS. SPECIFICALLY QUESTION B. I'm having trouble understanding how to get the answer properly I understand how to get answer A.

13. Ralf is a 9 year-old boy; he was scared by sound of a thunderstorm in 2010. Nobody was injured and no destruction took place. How likely it is that Ralf, because of this incident, would develop PTSD later in life? a. very likely b. somewhat likely c. very unlikely d. almost certainly, he has already developed a stress-related disorder 14. Delusion of communication was discussed in class. What is it? a. it is another name for hallucinations b. beliefs that all journalists are demons c. beliefs in being a communication major d. beliefs in being connected to other people, God, or the Devil e. beliefs about knowing many languages 15. Echolalia or echopraxia are symptoms that are common features of: a. PTSD b. Autism c. Bipolar Disorder d. delusion of reference e. catatonia 16. What are most typical psychological symptoms that accompany acculturative stress? a. hallucinations and delusions b. sleep disturbances caused by eating problems and sudden weight loss c. violent acts against relatives and friends d. anger, anxiety, depressive symptoms, and low self-esteem e. sleep disturbances, guilty feelings, and beliefs in own power, and ability to dominate other people 17. Why don’t most professionals such as firefighters and doctors working in emergency rooms develop symptoms of PTSD? a. because they take medication in the morning b. because they take special medication once a week c. because they are on therapy d. because they typically don’t experience intense fear when witnessing traumas e. because they have a genetic resistance to stress and fear 18. Symptoms such as failure to make eye contact, social withdrawal, lack of spoken language, and repetitive behaviors are among major symptoms of which disorder? a. PTSD b. ADD c. ADHD d. Tourette’s Disorder e. Autistic Disorder 19. What is the third group of symptoms typically identified in Attention Deficit/Hyperactivity Disorder? (The first one is Inattention, the second is Hyperactivity) a. excessive anxiety b. hallucinations c. motor tics d. obsessions and compulsions e. impulsivity 20. A person witnesses a traumatic event but does not develop symptoms of Stress Disorder. How common is this? a. this is very unusual: the person must develop a stress disorder b. this is unusual: most people develop a stress disorder under these circumstances c. this is common: most people in such circumstances don’t develop a stress disorder d. this is common but only in men e. women almost always develop a stress disorder in such circumstances 21. People who develop schizophrenia fall under the rule of “three thirds”. What is this rule? a. the rule explains that why women are not diagnosed with this illness b. the rule explains the negative symptoms of this illness c. the rule explains the positive symptoms of this illness d. the rule predicts how many people would likely to recover from illness e. the rule explains that why children are not diagnosed with this illness

Due to a recession, expected inflation this year is only 3.75%. However, the inflation rate in Year 2 and thereafter is expected to be constant at some level above 3.75%. Assume that the expectations theory holds and the real risk-free rate (r*) is 3.5%. If the yield on 3-year Treasury bonds equals the 1-year yield plus 1.5%, what inflation rate is expected after Year 1? Round your answer to two decimal places.

Cost Flow Relationships

The following information is available for the first year of operations of Creston Inc., a manufacturer of fabricating equipment:

Using the above information, determine the following amounts:

Assume a corporation is expecting the following cash flows in the future: $-9 million in year 1, $11 million in year 2, $23 million in year 3. After year 3, the cash flows are expected to grow at a rate of 6% forever. The discount rate is 13%, the firm has debt totaling $47 million, and 8 million shares outstanding. What should be the price per share for this company?

ABC Paper stock was $36per share at the end of last year. Since then, it paid a $1.50 per share dividend in the last year. The stock price is currently $35. Suppose you own 300 shares of ABC Paper. Which of the following statements is (are) correct?(x)Your dollar return on ABC Paper stock was $150 for the year.(y)Your percent return on ABC Paper stock was 1.39 percent for the year.(z)If you had owned more stock then you would have experienced a dollar return greater than $150 but the same percent return.

A.(x), (y) and (z)B.(x) and (y) onlyC.(x) and (z) onlyD.(y) and (z) onlyE.(z) only

You have a portfolio of fivestocks.You invested $5,150 in Intel(INTC), $6,520 in Tenneco(TEN), $10,345 in Alibaba(BABA), $4,370 in Aurora Cannabis (ACB)and $8,435in Occidental Petroleum(OXY). Which of thefollowing statements is (are) correct?(

x)The portfolio weight on the Intel stock is less than 0.146 and the portfolio weight on Occidental Petroleum (OXY) stockismore than 0.243.

(y)The combined portfolio weight of theTenneco and Aurora Cannabis stock is more than 0.308 but less than 0.316

z)If you sold off $1,000 of Alibaba stock and used that $1,000 to purchase Aurora Cannabis stock then the portfolio weight of Alibaba would fall from 0.297 to below 0.269and the portfolio weight of Aurora Cannabis stock would rise above 0.152.

A.(x), (y) and (z) B.(x) and (y) only    C.(x) and (z) only   D.(y) and (z) only E.(y) only

The income statement of XYZ Company for the 2016 financial year was below expectations
be low

a) What is the break-even point of the company?

b) The company proposes to reduce the selling price per unit by 10% and by doing so demand is expected to increase by 25%. What would be profit or loss if this proposal is implemented?

Suppose you are going to receive $ 35,000 per year for 18 years at the beginning of each year. Compute the present value of the cash flows if the appropriate interest rate is 14 percent. Round it two decimal places, and do not include the $ sign, e.g., 123456.78.