Acct 510 - MN CAFR Independent Assignment Page 1

Chapter 18 Lab => Government Accounting - MN Comprehensive Annual

Financial Report (CAFR)

Note: The MN CAFR is available online in the state of MN website (www.finance.state.mn.us).

NOTE: If you are not sure if you are interpreting a question correctly…just note your assumption.

Introduction Section

Transmittal Letter

1. What basis of accounting is this system maintained?

State Principal Officials

1. List the following:

a. Governor –

b. Attorney General –

c. State Auditor –

d. Chief Justice of the MN Supreme Court -

Financial Section

Management Discussion and Analysis (MD&A)

1. List the government wide financial statements.

2. List the three types of government activities broken down in the government wide financial

statements.

3. What type of activity would Metropolitan State University considered?

4. List the state’s top three component units.

5. The state’s funds are separated into three types of funds;

a. List the three fund types.

b. What fund is Metropolitan State University a part?

6. Explain in your own words the difference between Budgetary Basis vs. GAAP?

Basic Financial Statements

1. What % of Total Assets do Cash and Cash Equivalents (unrestricted) represent?

2. Why would the state of MN carry such a high % of cash and cash equivalents?

3. What is the amount of General Obligation Bonds Payable?

Acct 510 - MN CAFR Independent Assignment Page 2

a. Current

b. Noncurrent

c. Total

4. In descending order, list the five largest “General Revenue” sources and the dollar amounts

(exclude “Other Taxes” from your list). Hint: All are found in the tax section.

5. What is the difference between Program Revenues and General Revenues?

6. List the three largest net expenditures for the state; in the following format.

Description Expense Revenue Total Net Expenditure

1st

2nd

3rd

7. Compare Net Assets of Governmental Activities to the Total Fund Balance for Governmental

Funds.

a. What is the total difference?

b. List the largest asset and the largest liability driving this difference. Why do these

differences exist? Be specific (provide examples) in your explanation for the

difference.

c. Explain in your own words why there is a $ revenue difference.

8. Compare the Change in Net Assets of Governmental Activities to the Net Change in Fund

Balances for Governmental Funds.

a. What is the total difference?

b. List and explain the three largest reconciling differences.

9. How does the University of Minnesota compare to the State Colleges and Universities from

a financial perspective?

USE THE ARITCLE IN BELOW TO ANSWER ALL QUESTION

Celia Thaxter's Garden, Isles of Shoals, Maine

Imagine you've been asked to explain the artworks you chose for your paper to an eighth grade class. Your task, the instructor informs you, is to use simple words and sentences to give them a chance to see the artwork through your eyes.

The instructor gives you a worksheet with this list of questions. Before you speak to the class, you must answer the questions for each of your two artworks. No answer may be longer than one sentence. You are encouraged to make lists, use bullet points, use incomplete sentences. Stick to words you use every day and only use fancy terminology if there's no other way to say what you mean.

1. Title of the artwork
2. Name of the artist
3. Date of creation
4. Artwork medium (what it's made of)
5. Artistic movement, style, or period (i.e., Impressionist, classical, Renaissance)
6. Subject (what/who is in the work and what are they doing)
7. Where are your eyes drawn when you look at the artwork?
8. How do your eyes move around the artwork?
9. What are three colors that stand out in the artwork? If there are no colors or its just black and white, why aren't there colors?
10. Did the creator make the art for someone specific? (were they commissioned? did they have a noble patron? was it a gift?)
11. If they did make it for someone specific, is there anything in the artwork to tell you that? If there isn't, how did you learn it?
12. Was the artwork famous in its own time? In our time? What is it famous for?
13. One specific detail you like about the artwork and why.
14. One specific detail that has symbolic or persuasive meaning and what it means.
15. One specific detail in the artwork that the artist is known for.
16. If the students remember only one thing about this artwork besides its name and artist, what do you think they should remember.

In open tube CE a) How does chiral analysis work and with what additives? b) explain with detail why use coated capillaries? c) explain with detail why open tube CE shows high resolution towards certain samples? d) what are the differences between electrophoresis and electroosmosis in detail?

I would like you to determine if there are differences between two groups in our class data. You may choose to compare men and women, short people and tall people, people who like blue and people who like green, or any other split that you wish. It doesn’t matter how you decide to split up your groups. You will then select one QUANTITATIVE variable to compare between the two groups.Please turn in the following:

1. What two groups are you comparing? What variable are you using for your comparison?

Tall vs Short. Discrete Variable

2. Use our class data to select a sample for each of your groups. Describe, in detail, how you created your sample. You should include:

a. The statistical name of your sampling method

b. Detailed description of how you created your samples

c. A list of observation numbers and actual data for each of your samples

- Create 4 different statistical descriptors of your data.

- Are your two groups different, or similar? Use the statistics you created in number 3 as a basis of your decision.

CLASS DATA Height in inches:

62,73,69,67,66,63,60,71,67,61,62,64,62,66,68,63,64,74,64,66,74 64

68,66,61,68,62,73,73,63,61,67,73,65,67,65,69,73,64,60,70,62,63,66

64,70,70,66,72,65,63,71,69,74,65,67,74,68,73,59,67,65,70,66,74 ,64

64,69,63,68,63,69,66,65,66,62,72,71,63,60,83,69.5,65,68,68,66,59

67,65,65,65,65,68,73,74,69,65,74,66,67,62,62,73,76,65,65,63

68,63,59 ,72,71,65,66,72,64,63,68,62,64,67,64,74,70,70,66,71

69,67,67,65,63,74,66,72,65,68,62,69,62,72,70,71,64,61,75,77

71,73,72,69,67,65,70,61,67,58,62,60,61,60,72,63,72,65,73,65,66,65,69,68,67   

63,71,60,64,72,74,63,63,70,66,74,72,63,64,65,76,60,61,70,67,72,60,67,73,66,72,65,65,70,61,65 ,71,73 ,73,74,76,66,69,62

65,65,68,70,61,63,65,65,75,63,74,71,72,78,73,73,65,71,59,73,68,60,70,62,72,66,74,61,64,70,67,60,60,62,64,69,69,64,66,66,74,65,72,76,62,73,77,71,75, 70

Favorite color:

Pink, Blue, Red, Blue, Yellow, Pink, Purple, Orange, Green, Blue, Pink, Black, Pink, Red, Green, Orange, blue, Blue, Purple, Black, Blue, Gray, Purple, Purple, Blue, Purple, Purple, Red, Black, Purple, Pastel Green, Red, Teal, Pink, Orange, Black, Pink, Black, Lime, Black, Black, Pink, Blue, Blue, Green, Blue, Orange, Purple, Red, Purple, Pink, Red, Purple, Brown, Green, Purple, Green, Blue, Blue, Pink, Blue, Black, Blue, Black, Green, Purple, Yellow, Red, Green, Red, Purple, Red, Yellow, Purple, Blue, Blue, Purple, Orange, Pink, Blue, Pink, Blue, Red, Red, Pink, Blue, Rose Gold, Pink, Caroline Blue, Blue, Green, Blue, Blue, Green, Red, Purple, Blue, Orange, Red, Yellow, Blue, Red, Orange, purple, Purple, Blue, Blue, Black, Green, Yellow, Yellow, Green, Blue, Green, Green, Yellow, Pink, Blue, Pink, Blue, Pink, Green, Brown, Blue, Pink, Pink, Purple, Red, Teal, Black, Purple, Pink, Orange, Yellow, Blue, Purple, Blue, Red, Blue, Tan, Blue, Blue, Orange, Green, Blue, Red, Blue, Yellow, Black, Purple, Green, Black, Black, Gray, Brown, Black, Brown, Black, Brown, Black, Gray, Red, Blue, Green, Purple, Blue, Green, Yellow, Pink, Black, Blue, Blue, Pink, Red, Yellow, Green, Black, Purple, Orange, Brown, White, Blue, Green, Black, Yellow, Red, Pink, Green, Gold, Black, Orange, Green, Blue, Red, Pink, Blue, Purple, Green, Yellow, Pink, Blue, Yellow, B, B, G, Pink, G, B, Purple, Orange, Orange, Purple, Yellow, Blue, Blue, Pink, Blue, Blue, Orange, Blue, Gray, Blue, Blue, Green, Blue, Red, Black, Red, Blue, Purple, Black, Black, Red, Blue, Yellow, Black, Blue, Red, Red, Orange, Green, Blue, Maroon, Lavender, Green, Yellow, White, Black, Blue, Black, Orange, Red, Green, Blue, Blue, Orange, Yellow, Green, Red, Blue, Blue

Give a brief detail of the physiologic steps to muscle contraction. Explain with support of the appropriate chapters in your book.

We have multiple important muscles or muscle groups in the body. Chose one of the following and detail its attachment, insertion, the part of the body it moves, and anything else of particular importance: quadriceps; biceps; triceps; hamstrings; gluteus maximus; gluteus minimus; gastrocnemius; Sartorius; rotator cuff; pectorals; wrist flexors; wrist extensors; or tibialis anterior. Explain with support of the appropriate chapters in your book.

There are multiple types of cells in the nervous system. Choose one and detail its functions, shape, and anything special or particular about that type of cell. Explain with support of the appropriate chapters in your book.

Give a brief detail of the physiologic steps to muscle contraction. Explain with support of the appropriate chapters in your book.

We have multiple important muscles or muscle groups in the body. Chose one of the following and detail its attachment, insertion, the part of the body it moves, and anything else of particular importance: quadriceps; biceps; triceps; hamstrings; gluteus maximus; gluteus minimus; gastrocnemius; Sartorius; rotator cuff; pectorals; wrist flexors; wrist extensors; or tibialis anterior. Explain with support of the appropriate chapters in your book.

There are multiple types of cells in the nervous system. Choose one and detail its functions, shape, and anything special or particular about that type of cell. Explain with support of the appropriate chapters in your book.

To prepare for this Assignment, imagine that you have information about how 20 nursing students and 20 psychology students felt about starting PSYC 3002 on Day 1 of this class. You want to know if nursing students and psychology students felt differently about embarking on the Introduction to Basic Statistics journey. You can find the data set for this Assignment in the Weekly Data Set forum found in the Discussions area of the course navigation menu.

By Day 7

To complete this Assignment, submit your answers to the following. Use SPSS to determine if academic program is related to feelings about PSYC 3002 by computing the appropriate chi square test.

1. Recall the four scales of measurement you learned about in Week 1 (i.e., nominal, ordinal, interval, ratio). Explain what scale of measurement is used to measure academic program in this example. How do you know?
2. Explain what scale of measurement is used to measure feeling about PSYC 3002. Explain how you know.
3. State whether this scenario requires a goodness of fit test or a test of independence. Explain your answer.
4. Before computing the chi square, state the null hypothesis and alternative hypothesis in words (not formulas).
5. Identify the obtained χ2 using SPSS and report it in your answer document.
6. State the degrees of freedom and explain how you calculated it by hand.
7. Identify the p value using SPSS and report it in your answer document.
8. Explain whether you should retain or reject the null hypothesis and why.
9. Are the results statistically significant? How do you know?
10. Explain what you can determine about the relationship between academic program and feelings about PSYC 3002.

Please explain why long-term rates are usually higher than short-term rates

Please explain under what economic conditions long-term rates might not be higher than short-term rates.

Please use "the yield curve" in your answer and Please explain your answer "in detail"

You have a portfolio worth $100,000 consisting of two stocks, A and B. You invested $30,000 in stock A and the remainder in Stock B. Consider the following information:

Type your answers in the appropriate section showing all steps of your work

Expected return 3.75% ??                                              

Standard deviation ??               6.26%

a) What is the expected return for Stock B?

b) What is the standard deviation for Stock A?

c) What is the expected return for the portfolio of these two securities?

Hint: Use the weighted average of the stock’s individual standard deviation as that is all you have.

d) Are there benefits to forming a portfolio of these two securities? Explain in words.

f) Suppose the Beta of stock B = 1.8. You have determined the return on Government of Canada T-Bills = 3% and the return on the market portfolio = 12%. Is stock B correctly priced? Show your work and state whether you would recommend buying or selling Stock B and why.