Intermediate Accounting 3-Excel Spreadsheet

Intermediate Accounting 3



1 Excel Spreadsheet

You are a fresh accounting graduate. You have landed a job with a big 3 accounting firm. The first day at your job, your manager approaches you: “Hi Bill! Welcome aboard. Hope you like your new cubicle. Have you met everyone? By the way, you will be working with me from tomorrow on Long House Company. This is an important client. They have sent me some information on their projects. Can you provide a report that answers all of the questions listed below? By the way I need it by tomorrow morning at 8 a.m.!"
Project
Total Contract Price
Billings Through 12/31/12
Cash Collections Through 12/31/12
Contract Costs Incurred Through 12/31/12
Estimated Additional Costs to Complete
A
$200,000
$100,000
$80,000
$120,000
$90,000
B
250,000
50,000
45,000
40,000
180,000
C
180,000
180,000
150,000
120,000
0
D
100,000
10,000
5,000
80,000
20,000
E
140,000
120,000
110,000
100,000
10,000
 
870,000
460,000
390,000
460,000
300,000
Prepare a schedule of gross profit (loss) to be reported.
Prepare the entries for projects A and B only.Return on Investment – Education Funding
bus 401 week 3 assignment



Return on Investment – Education Funding



Develop a three- to four-page analysis (excluding the title and reference pages) on the projected return on investment for your college education and projected future employment. This analysis will consist of two parts:
Part 1: Explain how you made the decision to pursue an education in Business or Finance. Include a summary of expenses related to that decision, such as: cost of tuition, cost of books, the interest you may pay on any loans, and any other associated expenses.
Part 2: Conduct research on your desired occupation and identify how much compensation (return) you expect to earn. How long will it take to pay back the return on this investment? Be sure to consider the trade-off between the cost of education and the expected return on investment.
The research paper should be comprehensive and include specific examples. The paper should be formatted according to APA 6th edition style guidelines and must include at least two scholarly sources from the Ashford University Library or other scholarly sources.