Record the current price of the stock for each company you selected in Week 3's Stock Journal.
Question:
Using MS Excel spreadsheet or MS Word document put stock prices side-by-side, to show your comparison. Determine the current value of your total investment. Do not make any changes to your investment at this time. Calculate your total based on the number of shares and the new price per share, for each company. Provide your opinion / assessment of your investments. Evaluate the results of your current investment. Are you happy with the result and the trend? Are you upset because you're investment is worth less than $25,000. Feel free to speculate / guess at why you believe the stock increased, decreased, or remained static.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
The stock analysis for the three selected companies PepsiCo Inc Target Corporation and Kohl...View the full answer
Answered By
Asim farooq
I have done MS finance and expertise in the field of Accounting, finance, cost accounting, security analysis and portfolio management and management, MS office is at my fingertips, I want my client to take advantage of my practical knowledge. I have been mentoring my client on a freelancer website from last two years, Currently I am working in Telecom company as a financial analyst and before that working as an accountant with Pepsi for one year. I also join a nonprofit organization as a finance assistant to my job duties are making payment to client after tax calculation, I have started my professional career from teaching I was teaching to a master's level student for two years in the evening.
My Expert Service
Financial accounting, Financial management, Cost accounting, Human resource management, Business communication and report writing. Financial accounting : • Journal entries • Financial statements including balance sheet, Profit & Loss account, Cash flow statement • Adjustment entries • Ratio analysis • Accounting concepts • Single entry accounting • Double entry accounting • Bills of exchange • Bank reconciliation statements Cost accounting : • Budgeting • Job order costing • Process costing • Cost of goods sold Financial management : • Capital budgeting • Net Present Value (NPV) • Internal Rate of Return (IRR) • Payback period • Discounted cash flows • Financial analysis • Capital assets pricing model • Simple interest, Compound interest & annuities
65+ Reviews
86+ Question Solved
Related Book For 
Financial Analysis with Microsoft Excel
ISBN: 978-1285432274
7th edition
Authors: Timothy R. Mayes, Todd M. Shank
Question Posted:
