Using excel spreadsheets only!

Malfoy buys a home down the street from Hagrid for $342,000 and puts 10% down.  He finances the rest at 4.3% for 30 years.  

He decides to refi after 11 years at 3.8%.  If he pays the original payment, how much does he save?

The following extract is taken from an announcement released to the Australian Securities Exchange by the Australian Agricultural Company:

AACo announced today its trading results for the three months to 30 September 2003 (Q1 FY04) in which unaudited revenue was $22.1 million from cattle sales equivalent to 12.6 million kilograms. Compared to the same period in 2002, revenue decreased 14%, while sales volume increased 21%. Earnings before interest and tax (EBIT) for the three months to 30 September 2003 was ($3.2) million and compares with $7.7 million in the previous corresponding period.
The decrease in earnings was primarily due to there being no mark-to- market cattle value appreciation during the quarter compared to the previous corresponding period which saw a mark to market increase to trading cattle of 7.5%.
The lack of early spring rain saw many Queensland producers increase supplies of cattle to market during the quarter with the resulting downward pressure on prices as at 30 September 2003 impacting on the valuation of AACo cattle at that date. This trend has reversed in October, with prices rising in some categories in the order of 10%. Chief Executive Officer of AACO, Mr Peter Holmes à Court said 'We sold a high volume of cattle during the quarter, although the impact of last year's drought meant that they were generally at lighter weights. Prices, however, have subsequently risen due to the short supply of quality, finished cattle.'

Source: ASX Press Release, 30 October 2003, AACo First Quarter FY04 Briefing.
Required
(a) Explain what is meant by 'mark-to-market cattle value appreciation' in the context of AASB 141 'Agriculture'.

(b) Explain why no appreciation in the market value of cattle for the quarter ending 30 September 2003 resulted in a loss of $3.2 million compared to a profit of $7.7 million in the previous corresponding period.

(c) The volatile market conditions which had an impact on the Australian Agricultural Company serve to illustrate the principal difficulty of using fair value less costs to sell for biological assets.' Critically evaluate this comment.

Explain how each of the following affects the aggregate supply and/or aggregate demand curve and equilibrium GDP and prices in the short and long run. Does your answer depend on where the economy is in terms of full employment when the change happens?

Consumer spending increases

Investment spending increases

Government spending is reduced

US exports fall

Tax rates are lowered

Raw material (e.g., energy) prices rise

Wages increase

1. If the MPC is 0.9, what is the size of the multiplier and the total change in real GDP demanded following a $1 billion decrease in spending?
2. If the MPC is 0.8, what is the size of the multiplier and the total change in real GDP demanded following a $1 billion increase in spending?
3. If the MPC is 0.75, what is the size of the multiplier and the total change in real GDP demanded following a $10 billion increase in spending?
4. What are the 3 main tools of monetary policy?

A deficit-financed increase in government purchases

A. crowds out investment spending by decreasing interest rates.

B. crowds out investment by decreasing the exchange rate

C. ...is this even in English???!!!!

D. crowds out investment spending by increasing interest rates.

E. has no negative impact on consumption or investment.

F. crowds out consumer spending by reducing consumer incomes.

G. crowds out investment by increasing the exchange rate

Using the table below

Suppose you want to use the non-numeric variables “Nationality” and “First time visit”, as explanatory variables in a regression model regarding “Total spending”

i. How many “dummy variables” and which ones do you need to create?

ii. State a regression model of Total spending using as explanatory variables “PersonDays” (new variable computes as Total Persons X Days), “Nationality”, and “First time visit”. You believe that “Nationality” affects the slope coefficient of “PersonsDays”, while “First time visit” affects the intercept.

iii. Run the regression and state the estimated model for each Nationality distinguishing between first time and repeated visitors.

iv. Which coefficients are statistically significant?

v. Run the model after you remove the non-significant coefficients. Compare with the model in (ii) and comment

****NEED CODED IN C++, READ THE INSTRUCTIONS CAREFULLY AND PAY ATTENTION TO THE INPUT FILE, IT IS REQUIRED FOR USE IN THE PROBLEM****

You are to generate a list of customers to serve based on the customer’s priority, i.e. create a priority queue/list for a local company. The company has been receiving request and the request are recorded in a file, in the order the request was made. The company processes each user based on their priority, the highest priority which is the largest number. Priorities of equal value are first come first served as listed in the input file.  

Your input is a collection of customer IDs and priority, one per line.  

You are to read in the data and insert new data into a sorted linked list. The linked list is sorted by priority.

A customer may need an update on his order. He may submit a request a second time in order to change his priority level. If so, you will search the linked list, change the priority and adjust the new order in the sorted link list.

Input file: Priority Queue.txt

Output: List of ID’s with priorities in priority order

Example input:

1345 4

8243 1

Example output:

Customer Processing Order

Customer ID Priority

4124 5
1345 4

….    ….

Restrictions: Use an ordered link list for the data structure and a nice formatted print out.

INPUT FILE (NECESSARY TO IMPORT THE DATA INTO THE PROGRAM, NEEDS TO BE USED WITH IFSTREAM)

Priority Queue.txt

1432 2
8234 3
2124 5
8123 2
1314 2
1432 4
7141 3
7123 4
5523 1
6543 2
1731 5
3813 4
7213 5
3318 5
7213 3
7131 2
8882 3
9974 1
7221 3
7342 4
5523 3
3113 5
7002 4
9769 1
3145 5
7145 3
8834 2
9123 4
7878 1
7588 4
2025 1
6069 3
2025 3

The instructions can be translated as follows:

The objective is to make a priority queue/list.

The requests made to fill this queue include a 4-digit customer number and priority level ranging from 1 through 5.

This information is stored in a file.

If 2 customers have the same prio level, then the one that comes first in the list is treated as higher prio.

(first come, first serve basis)

I need to read in Priority Queue.txt to a sorted linked list. (sorted by prio)

I also need to insert new data into this linked list based on user input.

The input is based on a user being able to submit a 2nd request by entering their ID to change their prio level.

I can assume that when they do this, they bump their priority by 1. This is assumed because this program would serve no real function if every customer could just send another request and automatically be prio-5 or set that themself.

In this case, you want to search the Linked List, find the customer ID, change the prio, and adjust the new order in the sorted Linked List.

An ordered Linked List must be used for the data structure, and the output must be formatted neatly.

For input, this program will port in Priority Queue.txt for data.

For output, the program will display the Customer IDs in order of priority, keeping the FCFS rule in mind.

It will then prompt a user to be able to input their Customer ID for another request, bumping their prio by 1, re-sorting the LL, then outputting the new list.

Again, this is CODED IN C++ AND USES THE INPUT FILE FOR DATA.

Consider the following time series data.

Spending on social programs like Medicare and Medicaid have increased greatly over time. Provide a brief description of how you would evaluate spending on these programs to determine if they are socially useful.