Only Part a and b (Plan 1 & Plan 2) Using Excel only

J&J Cattle has purchased a quarter section of land for $160,000. They make a down payment of $20,000, and the remainder of the purchase price ($140,000) is financed at 11 percent compounded quarterly with quarterly payments over 2 years. Develop an Excel® table to illustrate the payment amounts and schedule for the loan, assuming payback follows

Plan 1: Pay the accumulated interest at the end of each interest period and repay the principal at the end of the loan period.

Plan 2: Make equal principal payments, plus interest on the unpaid balance at the end of the period.

Plan 3: Make equal end-of-period payments.

Plan 4: Make a single payment of principal and interest at the end of the loan period. A different plan: Pay off the principal per the table below. In addition, pay the accumulated interest at the end of each interest period.

A uniform current density given by:

J = (A/m2 J ) o az

give rise to a magnetic potential:

A = ( (Wb/m) 4 μo J o x ) 2 + y 2 i.

1) Apply the vector Poisson’s equation to prove the above statement.

2). Determine H using the expression of A

3). Determine H using the expression of J.

1.. How many total jobs in the U.S. were supported by FDI in the U.S. (direct and indirect) in 2013?

2. Which state’s exports supported the highest number of jobs? How many? Which state was number 2?  

3. Which are the top 2 industries in Texas for exports?

4.What is the dollar value of Texas exports going to Mexico (in billions)?

Automata Question.

Over the alphabet Σ = {a, b}:

1) Give a DFA, M₁, that accepts a Language L₁ = { w | w has exactly 2 a’s }

2) Give a DFA, M₂, that accepts a Language L₂ = { w | w has at least 2 b’s }

3) Give acceptor for L₁ intersection L₂

4) Give acceptor for L₁ - L₂

in.java

Write a program that reads an integer from the user and prints a rectangle of starts of width 5 3 and height N.

Sample run 1:
Enter N: 5
***
***
***
***
***
Bye

Sample run 2:
Enter N: 8
***
***
***
***
***
***
***
***
Bye

Sample run 3:
Enter N: 2
***
***
Bye

Sample run 4:
Enter N: -2
Bye

1. Mark Welsch deposits $7,100 in an account that earns interest at an annual rate of 8%, compounded quarterly. The $7,100 plus earned interest must remain in the account 5 years before it can be withdrawn. How much money will be in the account at the end of 5 years? (PV of $1, FV of $1, PVA of $1, and FVA of $1)

2. Dave Krug finances a new automobile by paying $6,800 cash and agreeing to make 10 monthly payments of $500 each, the first payment to be made one month after the purchase. The loan bears interest at an annual rate of 12%. What is the cost of the automobile? (PV of $1, FV of $1, PVA of $1, and FVA of $1

3. Otto Co. borrows money on April 30, 2016, by promising to make four payments of $22,000 each on November 1, 2016; May 1, 2017; November 1, 2017; and May 1, 2018. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided. Round "Table Factor" to 4 decimal places.)
How much money is Otto able to borrow if the interest rate is 4%, compounded semiannually?

4.

Compute the amount that can be borrowed under each of the following circumstances: (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided. Round your "Table value" to 4 decimal places.)

1. A promise to repay $90,000 five years from now at an interest rate of 7%.
2. An agreement made on February 1, 2016, to make three separate payments of $17,000 on February 1 of 2017, 2018, and 2019. The annual interest rate is 3%

5. Kelly Malone plans to have $43 withheld from her monthly paycheck and deposited in a savings account that earns 12% annually, compounded monthly. If Malone continues with her plan for two and one-half years, how much will be accumulated in the account on the date of the last deposit? (PV of $1, FV of $1, PVA of $1, and FVA of $1)

6. Starr Company decides to establish a fund that it will use 2 years from now to replace an aging production facility. The company will make a $105,000 initial contribution to the fund and plans to make quarterly contributions of $45,000 beginning in three months. The fund earns 8%, compounded quarterly. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided. Round your "Table Factor" to 4 decimal places and final answer to the nearest whole dollar.)

What will be the value of the fund 2 years from now?

A realtor in Arlington, Massachusetts, is analyzing the relationship between the sale price of a home (Price in $), its square footage (Sqft), the number of bedrooms (Beds), and the number of bathrooms (Baths). She collects data on 36 sales in Arlington in the first quarter of 2009 for the analysis. A portion of the data is shown in the accompanying table.

a. Estimate the model Price =  β₀ + β₁Sqft + β₂Beds + β₃Baths + ε. (Round Coefficients to 2 decimal places.)

Intercept. Coefficients for each?

Sqft

Beds

Baths

b. Predict the price of a 2,112 square-foot home with two bedrooms and one bathrooms. (Round coefficient estimates to at least 4 decimal places and final answer to the nearest whole number.)

$___?

Answer the dividend question below:

a. A is expected to pay a dividend of $2 per share to its shareholders one year from today. The dividend is then expected to grow year-over-year at a constant rate of 4% (EAR) in perpetuity. The equity cost of capital for A is 8%. What is the current price per share of A?

b. B is currently paying no dividends. It expects to begin paying a dividend of $3 per share to its shareholders 3 years from today. It will then continue to pay a $3 dividend per share each year in perpetuity. The equity cost of capital for B is 10%. What is the current price per share of B?

c. C is expected to pay a dividend of $4 per share for the next four years. The dividend is expected to start growing at a constant rate g immediately after the year 4 dividend. That is, the dividend per share in year 5 will be 4*(1+g), the dividend per share in year 6 will be 4*(1+g)2 , etc. Suppose the price of the C stock is currently $80 per share. If the C equity cost of capital is 10%, what must be the dividend growth rate g?

Problem#4

The stockholders equity section of Carey Co.'s balance sheet at December 31, 2014, was as follows:    

       Common stock--$10 par (authorized 1,000,000 shares, issued and outstanding 600,000 shares)                                      $6,000,000      

   Paid-in capital in excess of par                         $1,500,000       

   Retained earnings                                             $3,250,000                                                             

Total         $10,750,000

Instructions: Prepare journal entries (1, 2 and 4) and show proper disclosure (3) (stockholders equity section of b/s) to reflect the following treasury stock transactions showing how each is accounted for under the cost method. (show computations)

1. On January 4, 2015 having idle cash, Carey Co repurchased 25,000 shares of its out-standing stock for $500,000

2. On March 4, Carey sold 5,000 of these reqcquired shares at $24 per share.

3. Show the proper disclosures in the stockholders equity section of the balance sheet issued at the end of the firs quarter, March 31, 2015. Assume net income of $100,000 during the first quarter.

4. On June 30, 2015 the firm sold 10,000 of the reacquired shares for $17 per share.

Suppose the chance of getting flu is independent of each other. Suppose 20% of graduate school students nationwide develop influenza. Further, suppose we have a class of size 15. Let X be the number of students who get flu, calculate the following probabilities:

1. Exactly 4 get influenza. Which is the correct answer? There might be slight rounding differences. Please provide an explanation.

a. 0.500

b. 0.188

c. 0.123

d. 0.818

2. No more than 4 get influenza. Which is the correct answer? There might be slight rounding differences. Please provide an explanation.

a. 0.500

b. 0.836

c. 0.001

d. 0.368

3. Less than 4 get influenza. Which is the correct answer? There might be slight rounding differences. Please provide an explanation.  

a. 0.648

b. 0.846

c. 0.125

d. 0.684

4. How many students should the teacher expect to be sick with influenza that year? Which is the correct answer? The answer is NOT 3 students. There might be slight rounding differences. Please provide an explanation.

a. 2 students

b. 5 students

c. 1 student

d. 4 students