Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need this assignment today before midnight tonight. Case Study: Carol Jones Carol works as a business representative for an import/export company. Her job provides

I need this assignment today before midnight tonight.

image text in transcribed Case Study: Carol Jones Carol works as a business representative for an import/export company. Her job provides her with the opportunity to travel and experience new things. Because she travels so much, Carol feels that she does not have a handle on her finances. She has decided to pay a visit to a financial advisor for help. All items are monthly unless otherwise indicated: Carol's Salary $2,000 Auto Loan Payment New Home Cost $100,000 Mastercard Balance Gas/Heating $100 Visa Card Balance Electric $125 Bloomingdale Card Balance Water $60 Personal Loan Balance Internet/Cable $150 Mortgage Balance Home Phone $50 Mortgage Payment Cell Phone $200 New Car Cost Food $250 Gym Membership Mortgage Payment $796 Personal Loan Payment Car Insurance $165 Carol's 401K Balance Savings Balance $500 Auto Loan Balance Checking Balance $1,000 Visa Payment Lawn Service $100 Bloomingdale Payment Mastercard Payment $262 $5,000 $3,000 $1,500 $5,000 $95,000 $796 $20,000 $20 $94 $50,000 $15,000 $60 $30 $100 Int 15% Int 15% Int 29% Int 5%, 60 mos Assignment Requirements: Microsoft Excel spreadsheet with Three (3) Sheets: Create the following financial analyses using the information provided for Carol (Hint: first identify each item as an Asset, Liability, Cash Inflow or Cash Outflow): Sheet 1. a Balance Sheet, including a line item showing Carol's overall Net Worth. Sheet 2. a Cash Flow Statement, for a single month, including a line item showing Carol's overall Net Cash Flow. Organize cash outflows by Debt payments and Expenses, with subtotals for each. Format these 2 sheets professionally and consistently. APA formatting is NOT required. Sheet 3. Write a concise (1 paragraph each) response that addresses each the following items: 1. Apply financial planning concepts to advise Carol and explain how Carol can benefit from financial planning. Describe the benefits of using financial statements in financial planning. 2. Explain strategies that Carol can use to increase her net worth. How does this affect her cash flow? 3. Describe the sources available for asset management. 4. Compile a list of legal protections that can be used to protect Carol's assets. Format this sheet to be sure each response is fully legible in the cells in which typed (use wrap text if it runs off the screen). Use a separate cell(s) with section header for each of the above requirements. APA formatting is NOT required. Click the Assignment Files tab to submit your Microsoft Excel spreadsheet. Submit only 1 file for your assignment

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Advanced Accounting

Authors: Joe Hoyle

4th Edition

78136636, 978-0078136634

Students also viewed these Accounting questions