Is there an accounting expert available to do this project? How much is it to complete this project...

Question

Is there an accounting expert available to do this project? How much is it to complete this project on Target Corporation? I have attached the project instructions and the example word memo, and excel spreadsheet (multiple tabs) the professor provided on the company he did (Facebook). I am doing my project on Target Corporation. There is an excel spreadsheet and memo in word due.
The references I previously used are below and may be of help, but other prior year financial history may need to be researched

https://corporate.target.com/_media/TargetCorp/annualreports/2018/pdfs/2018-Target-Annual-Report.pdf

https://www.sec.gov/Archives/edgar/data/27419/ XXXXXXXXXX/tgt-20190202x10k.htm

final-project-instructions-34fqvb5f.docx

Pulkit · Accepted Answer

TO:                                       MBA 606 CLASS
COMPANY NAME:            TARGET CORPORATION
The excel spreadsheet has been prepared for the Company Target Corporation which contains financials for the last three years. The sheet contains Consolidated Income Statement, Consolidated Balance Sheet of past years and forecasted financials of future year is also made on the basis of assumption which is made on the basis of analysis of trend in past years such as in Sales, expenditures, assets etc. so that reasonable forecast can be done based on past years trend. The third part of the worksheet contains the details of some basic calculation which are-
1) Sales growth- On the basis of analysis of data of past three years it has been that the sales growth of the company has been around 3.4% from 2016 to 2017 and 3.7% from 2017 to 2018 so on the basis of growth expected the expected rate is 4.4% which is then use it up in the previous sale to find out the expected sales.
2) AP turnover- This ratio is calculated by dividing Cost of Sales with Average Accounts Payable which is in the present case has been calculated for the year 2018 by taking the average of Accounts Payable of the year 2017 and 2018 and which for the purpose of forecasting financial of 2019 AP ratio has been taken as 5.78.
3) Property,

Is there an accounting expert available to do this project? How much is it to complete this project on Target Corporation? I have attached the project instructions and the example word memo, and excel...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment