Loading
Home › Finance Help › Financial analysis project for a managerial accounting cl...
Status: Completed
 View Work

Financial analysis project for a managerial accounting class. It's in excel and I will attach the file for it as well as the url address for the annual report where the information is found. It is due tonight 11/4 at 11:59pm. This is my first time using the site so let me know if there is anything else you need from me or if the price is too low! Annual report url: https://investors.target.com/static-files/84b61f80-290f-48a2-b98b-99652641f14f

Date Posted: 04/11/2020
Category: Finance
Due Date: 04/11/2020
Instruction
Attached
Download File 1 (xlsx)
Tutor Uploads
Download File 1 (xlsx)
Bidders
committedwriter 5 years, 11 months ago
Rated 9.14 earned 89563.32 around 3017 assignments.
I am an expert in this subject with enormous experience kindly consider my bid as I will timely deliver quality work. Thank you.
$50.00
  • How early could you have it done and sent back to me?
    User_32379 | Nov 04, 2020, 23:16 PM
  • 3 hours
    committedwriter | Nov 04, 2020, 23:17 PM
  • Perfect. I don't need an A but close to it would be good. I'm going to choose you since you were first.
    User_32379 | Nov 04, 2020, 23:20 PM
  • Does that work for you?
    committedwriter | Nov 04, 2020, 23:20 PM
  • Okay
    committedwriter | Nov 04, 2020, 23:20 PM
  • Let me know if you need any more information!
    User_32379 | Nov 04, 2020, 23:23 PM
  • So everything I do on the excel right?
    committedwriter | Nov 04, 2020, 23:24 PM
  • Yes, correct! Does that still work for you?
    User_32379 | Nov 04, 2020, 23:28 PM
  • Yes ..I hope u will release the payment onces I upload the work for you
    committedwriter | Nov 04, 2020, 23:29 PM
  • Oh believe me I will. You have no idea how much this is saving me. I really appreciate it and also never thought I would use a service like this one but I just have too so once again thank you!
    User_32379 | Nov 04, 2020, 23:31 PM
  • I forgot to add the project instructions. I can send them in a message on here if you would like
    User_32379 | Nov 04, 2020, 23:36 PM
  • Just send here I see
    committedwriter | Nov 04, 2020, 23:37 PM
  • Information Sources Your primary source for your information will be the corporation’s annual report. You will also have to do some research on the internet. The link to the corporation’s most recent annual report is in the Financial Analysis Project folder in Blackboard. Please use the annual report listed in the assignment folder to ensure the numbers in your project tie with the numbers I am using to grade your project. If the numbers in your project do not tie to the numbers in the annual report, you will receive partial credit for those numbers I can verify.
    User_32379 | Nov 04, 2020, 23:40 PM
  • Excel The project is completed in an Excel Worksheet. Download the Financial Analysis Project Worksheet from Blackboard. Each step has its own worksheet in the file. An example project is available in the Financial Analysis Project folder. The project uses information from Casey’s General Stores. When your project is complete, submit your file in Blackboard. For those of you who do not have Excel on your computer, you should be able to access the software through the Office 365 link on your myDMACC page. If you are new to Excel, see the Tips and Tricks file to show you how to use Excel to make calculating your comparative common size financial statements and your ratios easier!
    User_32379 | Nov 04, 2020, 23:40 PM
  • Step 1: Get to Know Your Company 1. Go to your company’s most recent annual report. Be sure to use the link to the annual report listed in the Financial Analysis Project Worksheet. 2. Look through the annual report to find: • Annual Letter to Stockholders (Usually at the front of the report) • Financial Statements and Supplementary Data (Usually towards the middle or end) • Report of the Independent Registered Public Accounting Firm (Usually located right before the Financial Statements) • Notes to the Financial Statements (Usually found immediately following the financial statements) 3. Look for more information about your company on the internet. • Nasdaq: https://nasdaq.com • Yahoo Finance: https://finance.yahoo.com 4. Answer the questions in the Step 1 worksheet.
    User_32379 | Nov 04, 2020, 23:41 PM
  • Step 2: Create a Comparative Common Size Income Statement Comparative common size income statements are used to analyze the trends in a company’s revenues, expenses and net income. Looking at the income statement in the annual report, it is easy to see how revenue has changed over time. Seeing how expenses and net income has changed is not. You can tell if expenses and net income increased or decreased, but you can’t tell how they have changed relative to revenue. To address this issue, analysts convert the income statement dollars to percent of revenues. For this step: In columns A, B, C & D, create the income statement found in the company’s annual report in your Step 2 Worksheet. Include all of the lines found on the income statement. Be sure all of the lines included total your net income/loss.
    User_32379 | Nov 04, 2020, 23:41 PM
  • To the right of your income statement, in columns H, I J and K, create a comparative common-size income statement. Use the sales or revenue number as the base number. Compute the expenses and net income as percent of the base number. Round the percentages to one decimal place. (See the example in the Casey’s Project). For instructions on using Excel to add, subtract and calculate the percentages for you, see the Excel Instructions Worksheet.
    User_32379 | Nov 04, 2020, 23:41 PM
  • Step 3: Analyze the Income Statement Analyze the comparative common size income statement you created in Step 2 by answering the questions listed in the Step 3 Worksheet.
    User_32379 | Nov 04, 2020, 23:42 PM
  • Step 4: Create a Comparative Common Size Balance Sheet Comparative common size balance sheets are used to analyze the trends in a company’s assets, liabilities and equity. Total assets, liabilities and equity change from year to year so it is hard to compare the dollar numbers in the balance sheet and understand the changes in the individual line items in relation to each other. To address this issue, analysts convert the balance sheet dollars to percent of total assets. For this step: In columns A, B, and C create the balance sheet found in the company’s annual report in your Step 4 Worksheet. Include all of the lines found on the balance sheet. Be sure all of the items listed under assets equal Total Assets and that your Total Assets equal your Total Liabilities plus Equity.
    User_32379 | Nov 04, 2020, 23:42 PM
  • To the right of your balance sheet, in columns H, I, and J, create a comparative common-size balance sheet. Use the Total Assets number as the base number. Compute all of the listed assets as a percent of the base number. Compute all of the listed liabilities and equity numbers as a percent of the base number. Round the percentages to one decimal place. (See the example in the Casey’s Project).
    User_32379 | Nov 04, 2020, 23:42 PM
  • Step 5: Analyze the Balance Sheet Analyze the comparative common size balance sheet you created in Step 4 by answering the questions listed in the Step 5 Worksheet. Remember current assets are those assets that will be converted to cash or used by the business within the next operating cycle or 12 months, whichever is longer. Current liabilities are those obligations that are due within the next operating cycle or 12 months, whichever is longer.
    User_32379 | Nov 04, 2020, 23:42 PM
  • Step 6: Analyze the Statement of Cash Flow The Statement of Cash Flows is the statement creditors look at to determine if a company can pay their debt obligations. When the cash a company generates from operations is greater than net income, that means the company is able to pay their debts with cash generated by operating activities. That is the sign of a healthy company. Using cash generated from investing or financing activities to cover operating costs is not sustainable. Analyze the Statement of Cash Flow found in the annual report by answering the questions listed in the Step 6 Worksheet.
    User_32379 | Nov 04, 2020, 23:42 PM
  • Step 7: Notes to the Financial Statements The notes to the financial statement provides valuable information about the way the company gathers and records the financial information presented in the financial statements. This is the place investors go to learn how the company calculates the value of the inventory/co0st of goods and depreciation as well as other items listed in the financial statements. List the first six topics listed in the company’s notes to the financial statements. The notes to the financial statements are found directly following the financial statements in the annual report.
    User_32379 | Nov 04, 2020, 23:43 PM
  • Step 8: Financial Ratio Data Worksheet The purpose of this worksheet is to collect the financial information you need to calculate the financial ratios in Step 9. The numbers should come from the income statement in Step 2 and balance sheet in step 4. You will need to find the Take special care on the Income before Interest Expense and Income Taxes number. This number may not be listed on the income statement. You may need to calculate this by adding the Earnings before Income Taxes number and the interest expense. Also, the Annual dividends number is the total dividends paid during the year.
    User_32379 | Nov 04, 2020, 23:43 PM
  • You may find a company may not list a specific item on their financials. One example is Accounts Receivable. If a company does not list the information in their income statement or balance sheet, type NA in this worksheet.
    User_32379 | Nov 04, 2020, 23:43 PM
  • Step 9: Financial Ratio Calculation and Analysis 1. Using the information gathered in Step 8, calculate the ratios listed on Worksheet 9. Calculate these numbers yourself. Do not pull the information from Yahoo or Nasdaq. Please show your formula as well as your answer to earn partial credit. 2. For each ratio, write one or two sentences about what the ratio is telling you about the company. Chapter 17 of your text gives you a definition for each of the ratios. You can find more detailed information about each of the ratios in Chapters 1 – 14 in your text. Those chapters were covered in Prin I. If you still have your Prin I text you can find the information there. If you don’t have your Prin I text, you can access chapters 1 – 14 in your Connect ebook.
    User_32379 | Nov 04, 2020, 23:43 PM
  • Step 10: Final Thoughts 1. List three new things you learned about your company while completing this project. 2. Tell me if you would invest in your company. Why or why not?
    User_32379 | Nov 04, 2020, 23:43 PM
  • Alright that is all. Sorry it was a lot! I could post so much at a time due to the character limit
    User_32379 | Nov 04, 2020, 23:44 PM
  • Do those instructions make sense?
    User_32379 | Nov 05, 2020, 00:12 AM
  • Yes but I think u will have to adjust the price
    committedwriter | Nov 05, 2020, 00:13 AM
  • Meanwhile let me keep going
    committedwriter | Nov 05, 2020, 00:14 AM
  • Adjust the price in what way and why do you ask?
    User_32379 | Nov 05, 2020, 00:20 AM
  • Sorry that was not your text
    committedwriter | Nov 05, 2020, 00:21 AM
  • How are you able to do multiple assignments at a time? That's crazy. So I should expect to have it completed by 8:30? Is that what you said?
    User_32379 | Nov 05, 2020, 00:31 AM
  • Iam only working on your assignment.
    committedwriter | Nov 05, 2020, 00:34 AM
  • Oh okay I thought you might have meant to send that to someone else on this site. No worries!
    User_32379 | Nov 05, 2020, 00:38 AM
  • Okay
    committedwriter | Nov 05, 2020, 00:39 AM
  • Just wanted to reach out and see how it's going
    User_32379 | Nov 05, 2020, 01:54 AM
  • The going is okay
    committedwriter | Nov 05, 2020, 01:56 AM
  • Good to hear! Would you happen to know when it might be done?
    User_32379 | Nov 05, 2020, 02:05 AM
  • I am going to run an errand and should be back in 10-20 min. So, if I don't respond right away it's because I'm not back yet. Just letting you know
    User_32379 | Nov 05, 2020, 02:27 AM
  • Okay
    committedwriter | Nov 05, 2020, 02:29 AM
  • I don’t mean to send so many messages and distract you but could I get an ETA on when you think it will be done? I’m just getting anxious
    User_32379 | Nov 05, 2020, 03:08 AM
  • Am winding step 7
    committedwriter | Nov 05, 2020, 03:10 AM
  • Awesome thanks for the update!
    User_32379 | Nov 05, 2020, 03:12 AM
  • Welcome
    committedwriter | Nov 05, 2020, 03:15 AM
  • Is it close to being done? I have to turn it in pretty soon so please let me know as soon as you can! Thanks!
    User_32379 | Nov 05, 2020, 04:29 AM
  • Yes am in step 9
    committedwriter | Nov 05, 2020, 04:31 AM
  • Perfect thank you!
    User_32379 | Nov 05, 2020, 04:32 AM
  • Again, sorry for all of the messages I'm just an anxious person. Ready for it to be submitted??
    User_32379 | Nov 05, 2020, 05:09 AM
  • Sending to you now
    committedwriter | Nov 05, 2020, 05:10 AM
  • Thank you!! I will send the payment once I see it!!
    User_32379 | Nov 05, 2020, 05:12 AM
  • I'm guessing it will show up in the "uploaded homework" section and then I can download it from there correct?
    User_32379 | Nov 05, 2020, 05:17 AM
  • Yes. I have uploaded it. Please look at it and release the payment.You can reach me anytime for any question. If you are on whatsapp you can give me your number
    committedwriter | Nov 05, 2020, 05:18 AM
  • Have you seen the work
    committedwriter | Nov 05, 2020, 05:21 AM
  • Yes! Looks great!
    User_32379 | Nov 05, 2020, 05:22 AM
  • Thank you very much!!
    User_32379 | Nov 05, 2020, 05:22 AM
  • Welcome
    committedwriter | Nov 05, 2020, 05:40 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[0] $}

{$ showNewChatSuccessMsg[0] $}
Unable to send Message: {$ showChatProcessErrorMsg[0] $}
 
 
expert4u 5 years, 11 months ago
Rated 9.0 earned 77109.21 around 2331 assignments.
Hi, this is my area of expertise. Award me this project and you will be assured of quality work. Thank you
$60.00
  • How early could you have it done and sent back to me?
    User_32379 | Nov 04, 2020, 23:17 PM
  • It will be ready within 4 hours. Kindly assign me.
    expert4u | Nov 04, 2020, 23:19 PM
  • I'm making the analysis using the questions in the excel file, right?
    expert4u | Nov 04, 2020, 23:20 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[1] $}

{$ showNewChatSuccessMsg[1] $}
Unable to send Message: {$ showChatProcessErrorMsg[1] $}
 
 
kingz 5 years, 11 months ago
Rated 9.4 earned 52183.12 around 1434 assignments.
Hello assign this one to me i can guarantee you an A grade.
$65.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[2] $}

{$ showNewChatSuccessMsg[2] $}
Unable to send Message: {$ showChatProcessErrorMsg[2] $}
 
 
komatsu 5 years, 11 months ago
Rated 8.8 earned 25673.74 around 681 assignments.
Let me handle this
$50.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[3] $}

{$ showNewChatSuccessMsg[3] $}
Unable to send Message: {$ showChatProcessErrorMsg[3] $}
 
 
phoniextutor 5 years, 11 months ago
Rated 8.98 earned 50856.21 around 1767 assignments.
Hello my friend, kindly offer me this gracious opportunity to assist you. Pleasure.
$100.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}

{$ chatErrMsg[4] $}

{$ showNewChatSuccessMsg[4] $}
Unable to send Message: {$ showChatProcessErrorMsg[4] $}