on may 15 2006 you obtained an 82000, 15 year home loan at 5.1% compounded monthly,with the first payment due on june 15th 2006. The size of the monthly payment is $652.73
A. Find the balance due on the loan on December 15, 2011.
B. How much interest will be paid on the loan during 2012?
C. If you refinanced the loan on December 15, 2011 at 7.2% interest what will the size of the new payment if the term of the loan remains the same?
D. If you refinanced the loan on December 15, 2011 at 7.2% interest what will the term of the loan if the payment size remains the same?
E. If the original payment is rounded to $700 (and there is no change in the original interest rate), What will the size of the 162nd payment if it is increased from $700 to pay off the balance?
In: Accounting
In an effort to compare vegetation growth in an area a cluster sample was done in 2006 at 8 locations each 1 square foot and mapped with GPS coordiantes.
The next year the researchers came back to the same area to see if vegetation had increased. They used the coordinates and mapped the same square foot units. The data is in the table below. Test to see if vegetation has increased in 2007 from the year previous.
| 2006 | 2007 | |
| Location A | 124 | 132 |
| Location B | 35 | 56 |
| Location C | 21 | 12 |
| Location D | 245 | 270 |
| Location E | 151 | 180 |
| Location F | 78 | 81 |
| Location G | 95 | 11 |
| Location H | 82 | 96 |
Complete all 8 steps of a hypothesis test. You may skip making a histogram.
In: Statistics and Probability
The Seneca Children's Fund is a local charity that runs summer camps for disadvantaged children. The fund's board of directors has been working very hard in recent years to decr4ease the amount of overhead expenses, a major factor in how charities are rated by independent agencies. The following data show the percentages of the money the fund has raised that was spent on administrative and fund-raising expenses for 2006-2012.
Year Expense (%)
2006 13.7
2007 13.9
2008 14.8
2009 14.6
2010 14.9
2011 15.1
2012 15.6
a. Construct a time series plot. What kind of relationship exists in the data?
b. Develop a linear trend equation for these data.
c. Forecast the percentage of administrative expenses for 2013.
d. Using a smoothing constant of .2 forecast a value for 2013.
In: Math
Customers at the local Subway store order an ice tea with their meal 75% of the time. Use the Binomial distribution to find the answer to the following. __________
Find the probability that among the next 8 customers, at least 3 will order ice tea with their meal: Of the next 8 customers, how many do you expect to order ice tea with their meal? __________
What is the standard deviation of the number of customers that order ice tea among the next 8 customers? (to two places after the decimal) _______
In: Math
Using the Adjusted present value (APV) approach:
BTR Warehousing, which is considering the acquisition of Globo-Chem Co., estimates that acquiring Globo-Chem will result in an incremental value for the firm. The analysts involved in the deal have collected the following information from the projected financial statements of the target company:
|
Data Collected (in millions of dollars) |
|||
|---|---|---|---|
| Year 1 | Year 2 | Year 3 | |
| EBIT | $11.0 | $13.2 | $16.5 |
| Interest expense | 3.0 | 3.3 | 3.6 |
| Debt | 34.1 | 40.3 | 43.4 |
| Total net operating capital | 105.1 | 107.1 | 109.1 |
Globo-Chem Co. is a publicly traded company, and its market-determined pre-merger beta is 1.60. You also have the following information about the company and the projected statements:
| • | Globo-Chem currently has a $16.00 million market value of equity and $10.40 million in debt. |
| • | The risk-free rate is 5%, there is a 7.10% market risk premium, and the Capital Asset Pricing Model produces a pre-merger required rate of return on equity rsLsL of 16.36%. |
| • | Globo-Chem’s cost of debt is 7.00% at a tax rate of 30%. |
| • | The projections assume that the company will have a post-horizon growth rate of 4.00%. |
| • | Current total net operating capital is $102.0, and the sum of existing debt and debt required to maintain a constant capital structure at the time of acquisition is $31 million. |
| • | The firm does not have any nonoperating assets such as marketable securities. |
Given this information, use the adjusted present value (APV) approach to calculate the following values involved in merger analysis. (Note: Only round intermediate calculations when entering them as a final answer.)
|
Value |
|
|---|---|
| Unlevered cost of equity | 12.67% (other choices: 9.2%, 14.16%, 10.69%) |
| Horizon value of unlevered cash flows | (110.5, 114.56, 53.06, 86.85) |
| Horizon value of tax shield | (12.96, 12.46, 11.88, 20.76) |
| Unlevered value of operations | (95.47, 96.55, 61.40, 90.85) |
| Value of tax shield | (50.60, 11.40, 15.62, 61.58) |
| Value of operations | Value of operations: (157.05, 112, 106.47, 107.95)
Thus, the total value of Globo-Chem’s equity is (146.65, 86.15, 51, 97.55). Suppose BTR Warehousing plans to use more debt in the first few years of the acquisition of Globo-Chem Co. Assuming that using more debt will not lead to an increase in bankruptcy costs for BTR Warehousing, the interest tax shields and the value of the tax shield in the analysis, will (decrease/increase) , leading to a (higher/lower) value of operations of the acquired firm. The APV approach is considered useful for valuing acquisition targets, because the method involves finding the values of the unlevered firm and the interest tax shield separately and then summing those values. Why is it difficult to value certain types of acquisitions using the corporate valuation model? A) The acquiring firm usually assumes the debt of the target firm. Thus, old debt with different coupon rates usually becomes a part of the acquisition deal. B) The acquiring firm immediately retires the target firm’s old debt. Thus, the acquisition deal consists of only new debt in its capital structure. |
In: Finance
car.txt
0001|Mercury|LeSabre|2005|Brown|11000|2019-09-01
0002|Chevrolet|Aveo|2013|Blue|12000|2019-09-02
0003|Datsun|240Z|1979|Orange|13000|2019-09-03
0004|Ford|Galaxie|1964|Black|14000|2019-09-04
0005|Porsche|Boxster|2014|Green|15000|2019-09-05
0006|Honda|Insight|2007|Silver|16000|2019-09-06
1) Design and implement a class of "car" with constructor and destructor, with member variable for each field, and method for get and set each field. (2) Read the file (car.txt) to instantiate each object for each record read from the file. (3) After the file input is done, then display each object to the console.
Car List
Record #1
(1) carID=0001
(2) carManufacturer=Mercury
(3) carModel=LeSabre
(4) carYear=2005
(5) carColor=Brown
(6) carPrice=11000
(7) carInventoryDate=2019-09-01
and so on.
Task#2. Output each object to a file (car1.txt) with the same format as shown in Task#1.
Car List
Record #1
(1) carID=0001
(2) carManufacturer=Mercury
(3) carModel=LeSabre
(4) carYear=2005
(5) carColor=Brown
(6) carPrice=11000
(7) carInventoryDate=2019-09-01
// sample c++ code for object to binary file IO.
// try c++ to compile this program
#include <iostream>
#include <fstream>
using namespace std;
class Student
{
public:
char name[10];
char address[10];
char Gender;
char DOB[10];
Student()
{}
};
int main()
{
cout<<"\n Writting on file: Student1.txt \n";
Student *p=new Student;
cout<<1<<": ";
cin>>p->name;
cout<<"\n";
// to append use ios::app
// ofstream osfile("Student1.txt",ios::binary|ios::app);
ofstream osfile("Student1.txt",ios::binary);
osfile.write((char*)p,sizeof(Student));
osfile.close();
cout<<"\n reading Student1.txt \n";
Student *p2=new Student;
ifstream isfile("Student1.txt",ios::binary);
isfile.read((char*)p2,sizeof(Student));
isfile.seekg(0);
isfile.close();
cout<<1<<": ";
cout<<p2->name;
cout<<"\n";
return 0;
}
In: Computer Science
Exercise 9-4 Prepare a Flexible Budget Performance Report [LO9-4]
Vulcan Flyovers offers scenic overflights of Mount St. Helens, the volcano in Washington State that explosively erupted in 1982. Data concerning the company’s operations in July appear below:
| Vulcan Flyovers | ||||||
| Operating Data | ||||||
| For the Month Ended July 31 | ||||||
|
Actual Results |
Flexible Budget |
Planning Budget |
||||
| Flights (q) | 57 | 57 | 55 | |||
| Revenue ($355.00q) | $ | 16,400 | $ | 20,235 | $ | 19,525 |
| Expenses: | ||||||
| Wages and salaries ($3,500 + $89.00q) | 8,535 | 8,573 | 8,395 | |||
| Fuel ($30.00q) | 1,880 | 1,710 | 1,650 | |||
| Airport fees ($860 + $32.00q) | 2,559 | 2,684 | 2,620 | |||
| Aircraft depreciation ($10.00q) | 570 | 570 | 550 | |||
| Office expenses ($230 + $1.00q) | 455 | 287 | 285 | |||
| Total expense | 13,999 | 13,824 | 13,500 | |||
| Net operating income | $ | 2,401 | $ | 6,411 | $ | 6,025 |
The company measures its activity in terms of flights. Customers can buy individual tickets for overflights or hire an entire plane for an overflight at a discount.
Required:
1. Prepare a flexible budget performance report for July that includes revenue and spending variances and activity variances. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting
Financial Statement Creation – Use the information below to create B/S, I/S and Statement of Retained Earnings after adjusting for the four additional activities below.
|
Accounts Receivable |
$ |
7,500 |
|
Accounts Payable |
650 |
|
|
Cash |
3,700 |
|
|
Service Revenue |
14,500 |
|
|
Common Stock, $2 par, 10,000 authorized |
2,000 |
|
|
Common Stock, add’l pd in capital |
7,000 |
|
|
Equipment, at cost |
12,900 |
|
|
Accumulated depreciation |
2,300 |
|
|
Depreciation Expense |
700 |
|
|
Land |
5,800 |
|
|
Notes Payable, Due 2021 |
8,000 |
|
|
Investment Securities |
1,200 |
|
|
Prepaid Rent |
1,400 |
|
|
Rent Expense |
2,400 |
|
|
Retained Earnings, January 1, 2018 |
5,850 |
|
|
Salaries and Wages Expense |
7,700 |
|
|
Unearned revenue |
3,000 |
|
At year-end, the company accountant realizes that the following transactions have to be recorded:
In: Accounting
Exercise 9-4 Prepare a Flexible Budget Performance Report [LO9-4]
Vulcan Flyovers offers scenic overflights of Mount St. Helens, the volcano in Washington State that explosively erupted in 1982. Data concerning the company’s operations in July appear below:
| Vulcan Flyovers | ||||||
| Operating Data | ||||||
| For the Month Ended July 31 | ||||||
| Actual Results |
Flexible Budget |
Planning Budget |
||||
| Flights (q) | 55 | 55 | 53 | |||
| Revenue ($355.00q) | $ | 16,300 | $ | 19,525 | $ | 18,815 |
| Expenses: | ||||||
| Wages and salaries ($3,200 + $86.00q) | 7,898 | 7,930 | 7,758 | |||
| Fuel ($31.00q) | 1,873 | 1,705 | 1,643 | |||
| Airport fees ($860 + $34.00q) | 2,585 | 2,730 | 2,662 | |||
| Aircraft depreciation ($9.00q) | 495 | 495 | 477 | |||
| Office expenses ($200 + $1.00q) | 423 | 255 | 253 | |||
| Total expense | 13,274 | 13,115 | 12,793 | |||
| Net operating income | $ | 3,026 | $ | 6,410 | $ | 6,022 |
The company measures its activity in terms of flights. Customers can buy individual tickets for overflights or hire an entire plane for an overflight at a discount.
Required:
1. Prepare a flexible budget performance report for July that includes revenue and spending variances and activity variances. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
In: Accounting
Financial Statement Creation – Use the information below to create B/S, I/S and Statement of Retained Earnings after adjusting for the four additional activities below
|
Accounts Receivable |
$ |
7,500 |
|
Accounts Payable |
650 |
|
|
Cash |
2,700 |
|
|
Service Revenue |
16,500 |
|
|
Common Stock, $2 par, 10,000 authorized |
2,000 |
|
|
Common Stock, add’l pd in capital |
7,000 |
|
|
Equipment, at cost |
12,900 |
|
|
Accumulated depreciation |
2,300 |
|
|
Depreciation Expense |
700 |
|
|
Land |
5,800 |
|
|
Notes Payable, Due 2021 |
8,000 |
|
|
Investment Securities |
1,200 |
|
|
Prepaid Rent |
1,400 |
|
|
Rent Expense |
2,400 |
|
|
Retained Earnings, January 1, 2018 |
5,850 |
|
|
Salaries and Wages Expense |
8,000 |
|
|
Unearned revenue |
300 |
|
At year-end, the company accountant realizes that the following transactions have to be recorded:
In: Accounting