finance hw

/in /by

In today’s fast-paced academic environment, students often find themselves juggling multiple responsibilities, from attending classes and working part-time jobs to participating in extracurricular activities. The demands of modern education can be overwhelming, leaving students in search of effective solutions to manage their academic workload efficiently. One such solution is the use of Nursingpapertutors.com academic writing website. Nursingpapertutors.com academic writing website employ a cadre of experienced and knowledgeable writers who are well-versed in various academic subjects and writing styles. Nursingpapertutors.com professionals bring a wealth of expertise to the table, enabling them to produce well-researched and well-structured papers that meet the academic standards and expectations of students. Their familiarity with diverse subjects ensures that students can receive assistance across a wide spectrum of disciplines, from mathematics to literature, and from nursing to engineering.

 

below is the homework and attached is an exampled plus the spreadsheet the hw answers go into

 

Complete the following problems. For assistance, you may want to refer to these examples: Week 06 Example Problems.doc

Download the Week 06 Excel Problems spreadsheetto use in completing your problems. There are four separate worksheets within the workbook, one for each problem. Select the proper tab to complete each assignment. You will need to complete all yellow shaded cells.

Listed below is the current data for ABC Company:

ABC Company
Balance Sheet
December 31, 20xx

Assets

Liabilities and Equity

Cash

$10,000,000

Accounts Payable

$20,000,000

Accounts Receivable

250,000,000

Long-term debt

400,000,000

Inventory

120,000,000

Common Stock ($10 par, 1,000,000 outstanding)

10,000,000

Plant and Equipment

325,000,000

Paid-in capital

90,000,000

 

 

Retained Earnings

185,000,000

Total

$705,000,000

Total

$705,000,000

The current price of a stock is $58 per share.

Required:

  1. Construct a balance sheet after a two for one stock split. What will be the new price of the stock? (Problem 1 tab)
  2. Construct a balance sheet after a 5% stock dividend. What is the new price of the stock? (Problem 2 tab)
  3. Construct a balance sheet after a one for two reverse stock split. What is the new price of the stock? (Problem 3 tab)
  4. Construct a balance sheet after a $3 per share cash dividend. What is the total cash dividend? (Problem 4 tab)

 

One of the significant challenges students face is time management. The demands of coursework, assignments, and exams can create immense pressure, leading to stress and a potential drop in academic performance. Nursingpapertutors.com academic writing website can be a valuable resource for students seeking to balance their responsibilities effectively. By outsourcing some of their academic tasks, students can free up time to focus on studying, participating in meaningful extracurricular activities, or even addressing personal obligations. This improved time management can alleviate the stress associated with academic overload. The ultimate goal of education is to enhance one’s knowledge and skills. Nursingpapertutors.com academic writing websites can play a vital role in achieving this goal by providing students with well-crafted papers that serve as models for their own work. These papers can offer valuable insights into effective research, organization, and writing, thereby empowering students to improve their academic performance over time.

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.