SDC Accounting 302 - Assignment 3
pdf
keyboard_arrow_up
School
Excelsior University *
*We aren’t endorsed by this school
Course
302
Subject
Accounting
Date
Apr 3, 2024
Type
Pages
6
Uploaded by JudgeSteel13901
® Study.com Accounting 302 - Assignment 3: Forecasting Problem Set If you have a Study.com College Saver membership and are seeking college credit for this course, you must complete three assignments and pass the proctored final exam. Please submit your assignments before registering for the final. Below you will find prompts and instructions for submitting Assignment 3. About this Assignment The purpose of financial forecasts is to assess current and future fiscal conditions to inform policy and other important decisions. Financial forecasts are fiscal management tools that present estimated information based on past, current, and projected financial conditions. This assignment will measure your understanding of the purpose for, and importance of financial forecasts and how they contribute to decision making. Please note that you are required to complete all four of the following problem sets. Before beginning the assignment, please read the rubrics carefully to understand the expectations and how your work will be graded. Please write your answers succinctly and remain on topic, answering only to what is asked. Problem Set Stock Price Forecast What can | help you with today? X Read more
$150 $125 $100 - $75 $50 < 1970 1980 - Estimate Historical © NPV Calibration Point 1990 Forecast » 2000 2010 2020 2030 - e e 3% growth © Bubble/Bust Calibration Point Problem # 1: Refer to the stock price forecast table provided and any other resource material you deem necessary to address the following: * Summarize the forecast using 6-10 brief bullet points * |n 100-200 words explain how the forecasters might have utilized the historical data for the stock price to forecast future stock prices and the methodology for forecasting that the forecaster might have used. * What assumptions did the forecaster use? What might be some of the rational for making the assumptions? How would different assumptions affect the forecast? (100-200 words) ¢ [f you were advising investors regarding the organization's stocks, what would you tell them? Comment on when, and how much (if any) investment should be done, the return they can expect, time frames, and possible risks. (100-200 words) Problem # 2. For this question, please refer to the Dino's After School Trial Balance with ending totals for December 31, 2014 in the table below: Account Balance ($) Checking 15,220 Savings 58,500 Money Market 41,650 Pre-Paid Rent 5,400 Accounts Receivable 81,000 Accounts Receivable Allowances | -6,500 What can | help you with today? X Read more
Machinery 122,600 Equipment 80,300 Automobiles 67,500 Accounts Payable 60,000 Loans Payable 21,300 Equity 384,370 1. Using an Excel Spreadsheet, create the Balance Sheet for Dino's After School. 2. Using the information obtained from your Balance Sheet, calculate any one (1) liquidity and any one (1) leverage ratio. 3. Comment on the financial position of the organization, specific to the two ratios you calculated. What is the main reason that Dino's (and other organizations) need a Balance Sheet? (100-200 words) Problem # 3. Please refer to the corporate tax rates table and the Gross Profit Chart below: Account Balance ($) 0 to 50,000 15% 50,000 to 75,000 $7,500 + 25% of the amount over 50,000 75,000 to 100,000 $13,750 + 34% of the amount over 75,000 100,000 to 335,000 $22,250 + 39% of the amount over 100,000 335,000 to 10,000,000 $113,900 + 34% of the amount over 335,000 10,000,000 to 15,000,000 $3,400,000 + 35% of the amount over 10,000,000 15,000,000 to 18,333,333 $5,150,000 + 38% of the amount over 15,000,000 18,333,333 and up 35% Fiscal Year Gross Profit ($) June, 2009 - May, 2010 261,100 June, 2011 - May, 2012 277,500 June, 2012 - May, 2013 292,000 June, 2013 - May, 2014 300,900 1. Given the information provided here perform your own calculations to show the amount of corporate tax paid for each of the four (4) fiscal years covered in WBaL e d bR you with today? X 2. Is there a pattern? Explain the pattern and what it Readgageest about the future performance of the organization. How can this conclusion advise investors and arganizational decision makers? 3. If there was a 20% reduction in the Gross Profit for fiscal year 6/12 - 5/13, how might this have changed the gross profit expectations for the 6/13 - 5/14 fiscal year? Provide rationale.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
4, Calculate the total expected taxes that would have been paid for these two fiscal years, with the 20% reduction in 6/12 - 5/13 and the resultant expected change in the 6/13 - 5/14 gross profit. Problem # 4: Explain the concept of departmentalized accounting and the importance of collaboration between departments within an organization, to its success. You may use organizational examples. (200-350 words) Related Lessons The following lessons from the course may help you with this assignment. * What is Forecasting in Business? - Definition & Models ® Business Forecasting: Methods & Analysis * [mportant Ratios in Financial Forecasting ® Accuracy & Error in Financial Forecasting Grading Rubric This assignment will be graded based on the following rubrics: Category Unacceptable Needs Improvement Good Excellent Forecasting The summary, advice, or rationale are inaccurate, unclear, illogical and/or lack substance (0-2) Few parts of the summary, advice, and rationale are accurate, clear and logical (3-6) Most of the summary, advice, and rationale are accurate, clear and logical. (7-10) The summary, adv and rationale are accurate, clear and logical. All compon are thoroughly answered (11-12) Balance Sheet The formatting, calculations, and comments/conclusions are incorrect, unclear and/or lack substance (1-3) Some components of the formatting, calculations, and comments/conclusions are inaccurate, unclear and/or lack substance (4-7) Most/many formatting, calculations, and comments/conclusions are correct, fairly well formulated and articulated (8-12) All or most formatt calculations, and comments/conclus are correct well formulated and articulated (13-15) Taxes The calculations and analyses are either inaccurate, unclear and/or lack substance. (0-3) Some of the calculations and il\?hat can | he analyses are correct, clear, and hased 0o the information provided (4-7) e e '&}/rect, cfiear and based on the information provided (8-12) The calculations ar analyses are corre clear, thordugh an based on the information provid (13-15)
, Satisfactorily , Did not clearly , Clearly articulates _ .. | Attempted to articulates the _ articulate the necessity . : . necessity of _ articulate the necessity | necessity of _ : of departmentalized , : departmentalized Departmentalized _ of departmentalized departmentalized , ) accounting nor the , _ accounting and the Accounting _ accounting, but accounting and the , importance of co- , , importance of co- L response lacks clarity | importance of co- L ordination and L ordination and . and/or depth (2) ordination and ) collaboration. (0-1) , collaboration (4-5) collaboration. (3) Incorrect spelling, Several/Many Few instances of No or very few punctuation, instances of incorrect | incorrect spelling, instances of incorr Mechanics capitalization, and use | spelling, punctuation, | punctuation, spelling, punctuatis of standard English capitalization, and capitalization, and capitalization, and grammar hinders usage of standard usage of standard usage of standard understanding (0) English grammar (1) English grammar (2) English grammar (- Before You Submit When you are done with your assignment, we suggest taking some time to check for any errors or to add some final touches. We also suggest that you use online plagiarism checkers such as PlagScan or DupliChecker to make sure that your essay is not too similar to any existing materials. Plagiarized submissions will NOT be graded. How to Submit Your Assignment When you are ready to submit your problem set, please fill out the submission form and attach your assignment as a Microsoft Word, PDF, or Text document. After turning in all your assignments, you may go ahead and take the proctored final exam. You do not need to wait for these assignments to be graded. You should receive your project grades within one week. If you are not satisfied with the score you receive on your assignments, you may revise or rewrite them and resubmit them for grading using the same submission form above. Keep in mind that the grade you receive on this assignment is only a portion of your overall grade for the course, and you are free to retake the proctored final exam as well if you choose. Please see the course syllabus for a more detailed breakdown of the grading policy. @ Like this lesson @ Share What can | help you with today? X Read more Explore our library of cver 88,000 lessons
Search | Search Courses & Lessons Q Browse Browse by subject What can | help you with today? Read more
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Personal Financial Statement Project
For the Personal Financial Statement Project:
1. Record the events on the next page in the accompanying
formula worksheet
2. Write out the journal entries for the events on the next page
3. Create the financial statements with the ending information
from the worksheet
4. Once you have your Financial Statements completed,
please make a comment or two in the online text input box
about what the information is telling you
Event List
1. Opened a bank account with previously earned (retained
earnings) money for $100,000
2. Bought a house by paying $75,000 down in cash and taking a
loan of $225,000
3. Bought a vehicle by paying $1,000 down in cash and taking a
loan of $44,000
4. Worked (performed services) to clients for $80,000 cash
5. Paid for materials used (expense) in the services performed
with cash for $50,000
6. Paid for repairs and utilities of the house and vehicle (just
regular expenses) with cash for $8,500
7. During the year, you paid $5,000…
arrow_forward
Balance Sheet. Use Table 3.2 on page 82 as a guide to create a monthly balance sheet
arrow_forward
What is the propuse of a statement of activities in government-wide financial reporting?
arrow_forward
Question -
A formalized report that summarizes your current financial situation, analyzes your
financial needs, and recommends future financial activities is:
the life cycle model
a balance sheet
a personal financial plan
a tax return
arrow_forward
Prepare an explanatory memorandum about financial performance and record keeping requirements.
The operations manager of Metharom Construction has asked you to prepare an explanatory memorandum for the accounting staff.
They have requested that you include the following information:
A) a description of a minimum of 5 financial records that the company must maintain
B) any three factors while selecting software that could assist with finance management for small business
C) list any 5 regulatory requirement for lodgement and payment of statutory obligations
D) a set of policies to for Debt recovery procedures (minimum 3)
E) explain how financial performance will be monitored (include a minimum of 2 key performance indicators)
F) set of minimum 6 written financial procedures for Metharom which will help in financial health check for stakeholders
G)This document must then be sent electronically to the Operations Manager (your assessor) as well as submitted in hard copy.
arrow_forward
HAving troucble making a ( thesis statement on financial literacy course ) ? Talking about accounting
arrow_forward
Courses
=HCS380 Week 1 Terminology Matching
Accounts Receivable
Terminology Matching
Note Payable
Bonds Payable
Common Stock
Income Statement
Balance Sheet
Retained Earnings Statement
Statement of Cash Flow
Basic Accounting Equation
multimedia.phoenix.edu
Annual Report
View Assessment
HCS/380: Week 1 - Terminology Matching - Academic Resources
Owed to a bank for the money borrowed
Bill customer/patient for services
HCS
Debt securities sold to investors that must be repaid at a
particular date in the future
A AOL PASSV
REQUIRED
Enter your password for "kaylakı
Accounts.
Prepared by corporate management to present financial
information, management discussion, notes, and auditor's report
Used by creditors to determine if they will be paid
Assets Liabilities+Stockholder's Equity
Used by creditors and investors to analyze the organization's
cash position
Used by investors to evaluate the organization's history of
paying high dividends
The total amount paid in by stockholders for the share…
arrow_forward
Short Answer Essay Question:
DAS
• Understanding Fundamentals of Personal Finance
• Career Planning
• Financial Statements, Tools, and Budgets
• Managing Income Taxes
• Managing Checking & Savings Accounts
• Building & Maintaining Good Credit
• Credit Cards & Consumer Loans
• Vehicles & Other Major Purchases
What are three key things you have learned from any of the areas above, that you have adopted in your own personal financial
management practices?
arrow_forward
Describe the importance of a credit score for financial planning.
List the credit bureaus and list information that is contained in a person's credit report.
Review at least two sources of free credit reports, such as Credit Karma
arrow_forward
In light of the full disclosure principle, investors and creditors need to know the balances for assets, liabilities, and equity as well as the accounting policies adopted by management to measure the items reported in the balance sheet.
Instructions
If your school has a subscription to the FASB Codification, go to http://aaahq.org/asclogin.cfm to log in and prepare responses to the following. Provide Codification references for your responses.
(a)
Identify the literature that addresses the disclosure of accounting policies.
(b)
How are accounting policies defined in the literature?
(c)
What are the three scenarios that would result in detailed disclosure of the accounting methods used?
(d)
What are some examples of common disclosures that are required under this statement?
arrow_forward
Select one topic from the list below related to money and banking for the course. Once you have selected your research topic, review the materials in the text that can help you get started, and then begin conducting outside research using the online library, the internet, the Wall Street Journal websites, the Economist, and so forth.
Your mini research paper should have the following.
It should be approximately four to five pages (excluding reference and title pages).
It should be written in APA format to include a title page, citations as appropriate, and a reference page at the end. APA format is double-spaced, indented paragraph format.
These short papers do not require an abstract or running head.
Topics (select one)
What are the effects of electronic transactions and banking on the industry or monetary policy? Have innovations created greater or less efficiency? What has been the role of the Federal Reserve?
arrow_forward
Select one topic from the list below related to money and banking for the course. Once you have selected your research topic, review the materials in the text that can help you get started, and then begin conducting outside research using the online library, the internet, the Wall Street Journal websites, the Economist, and so forth.
Your mini research paper should have the following.
It should be approximately four to five pages (excluding reference and title pages).
It should be written in APA format to include a title page, citations as appropriate, and a reference page at the end. APA format is double-spaced, indented paragraph format.
These short papers do not require an abstract or running head.
Topics (select one)
What are the effects of electronic transactions and banking on the industry or monetary policy? Have innovations created greater or less efficiency? What has been the role of the Federal Reserve?
800 Words Requirement
arrow_forward
Please help
arrow_forward
During the semester, we have discussed threats and controls. Evaluate the following statement. “Accounting independence in accounting information system is important” Discuss using examples.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Related Questions
- Personal Financial Statement Project For the Personal Financial Statement Project: 1. Record the events on the next page in the accompanying formula worksheet 2. Write out the journal entries for the events on the next page 3. Create the financial statements with the ending information from the worksheet 4. Once you have your Financial Statements completed, please make a comment or two in the online text input box about what the information is telling you Event List 1. Opened a bank account with previously earned (retained earnings) money for $100,000 2. Bought a house by paying $75,000 down in cash and taking a loan of $225,000 3. Bought a vehicle by paying $1,000 down in cash and taking a loan of $44,000 4. Worked (performed services) to clients for $80,000 cash 5. Paid for materials used (expense) in the services performed with cash for $50,000 6. Paid for repairs and utilities of the house and vehicle (just regular expenses) with cash for $8,500 7. During the year, you paid $5,000…arrow_forwardBalance Sheet. Use Table 3.2 on page 82 as a guide to create a monthly balance sheetarrow_forwardWhat is the propuse of a statement of activities in government-wide financial reporting?arrow_forward
- Question - A formalized report that summarizes your current financial situation, analyzes your financial needs, and recommends future financial activities is: the life cycle model a balance sheet a personal financial plan a tax returnarrow_forwardPrepare an explanatory memorandum about financial performance and record keeping requirements. The operations manager of Metharom Construction has asked you to prepare an explanatory memorandum for the accounting staff. They have requested that you include the following information: A) a description of a minimum of 5 financial records that the company must maintain B) any three factors while selecting software that could assist with finance management for small business C) list any 5 regulatory requirement for lodgement and payment of statutory obligations D) a set of policies to for Debt recovery procedures (minimum 3) E) explain how financial performance will be monitored (include a minimum of 2 key performance indicators) F) set of minimum 6 written financial procedures for Metharom which will help in financial health check for stakeholders G)This document must then be sent electronically to the Operations Manager (your assessor) as well as submitted in hard copy.arrow_forwardHAving troucble making a ( thesis statement on financial literacy course ) ? Talking about accountingarrow_forward
- Courses =HCS380 Week 1 Terminology Matching Accounts Receivable Terminology Matching Note Payable Bonds Payable Common Stock Income Statement Balance Sheet Retained Earnings Statement Statement of Cash Flow Basic Accounting Equation multimedia.phoenix.edu Annual Report View Assessment HCS/380: Week 1 - Terminology Matching - Academic Resources Owed to a bank for the money borrowed Bill customer/patient for services HCS Debt securities sold to investors that must be repaid at a particular date in the future A AOL PASSV REQUIRED Enter your password for "kaylakı Accounts. Prepared by corporate management to present financial information, management discussion, notes, and auditor's report Used by creditors to determine if they will be paid Assets Liabilities+Stockholder's Equity Used by creditors and investors to analyze the organization's cash position Used by investors to evaluate the organization's history of paying high dividends The total amount paid in by stockholders for the share…arrow_forwardShort Answer Essay Question: DAS • Understanding Fundamentals of Personal Finance • Career Planning • Financial Statements, Tools, and Budgets • Managing Income Taxes • Managing Checking & Savings Accounts • Building & Maintaining Good Credit • Credit Cards & Consumer Loans • Vehicles & Other Major Purchases What are three key things you have learned from any of the areas above, that you have adopted in your own personal financial management practices?arrow_forwardDescribe the importance of a credit score for financial planning. List the credit bureaus and list information that is contained in a person's credit report. Review at least two sources of free credit reports, such as Credit Karmaarrow_forward
- In light of the full disclosure principle, investors and creditors need to know the balances for assets, liabilities, and equity as well as the accounting policies adopted by management to measure the items reported in the balance sheet. Instructions If your school has a subscription to the FASB Codification, go to http://aaahq.org/asclogin.cfm to log in and prepare responses to the following. Provide Codification references for your responses. (a) Identify the literature that addresses the disclosure of accounting policies. (b) How are accounting policies defined in the literature? (c) What are the three scenarios that would result in detailed disclosure of the accounting methods used? (d) What are some examples of common disclosures that are required under this statement?arrow_forwardSelect one topic from the list below related to money and banking for the course. Once you have selected your research topic, review the materials in the text that can help you get started, and then begin conducting outside research using the online library, the internet, the Wall Street Journal websites, the Economist, and so forth. Your mini research paper should have the following. It should be approximately four to five pages (excluding reference and title pages). It should be written in APA format to include a title page, citations as appropriate, and a reference page at the end. APA format is double-spaced, indented paragraph format. These short papers do not require an abstract or running head. Topics (select one) What are the effects of electronic transactions and banking on the industry or monetary policy? Have innovations created greater or less efficiency? What has been the role of the Federal Reserve?arrow_forwardSelect one topic from the list below related to money and banking for the course. Once you have selected your research topic, review the materials in the text that can help you get started, and then begin conducting outside research using the online library, the internet, the Wall Street Journal websites, the Economist, and so forth. Your mini research paper should have the following. It should be approximately four to five pages (excluding reference and title pages). It should be written in APA format to include a title page, citations as appropriate, and a reference page at the end. APA format is double-spaced, indented paragraph format. These short papers do not require an abstract or running head. Topics (select one) What are the effects of electronic transactions and banking on the industry or monetary policy? Have innovations created greater or less efficiency? What has been the role of the Federal Reserve? 800 Words Requirementarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning