Chat Now Available 24/7
Log in
Chat Now
Log in
Order Now

Order For Similar Custom Papers & Assignment Help Services

Fill the order form details - writing instructions guides, and get your paper done.

Check Prices
Order Now

Posted: April 20th, 2022

Finance Report

DCF Valuation
$ in millions Actual Pro Forma
12/31/18 12/31/19 12/31/20 12/31/21
Wiggins, James: Change this row if the company has a different fiscal year end 12/31/22 12/31/23 12/31/24 12/31/25 12/31/26 12/31/27 12/31/28
Total Assets Year End 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Assets Growth Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0.0%
Interest Income/Avg Total Assets ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0.0%
Interest Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Interest Expense/Avg Total Liabilities ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0.00%
Interest Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Provision for Loan Loss/Avg Total Assets ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0.00%
Provision for Loan Loss 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Non Interest Income/Avg Total Assets ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0.00%
Non Interest Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Non Interest Expense/Avg Total Assets ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0.00%
Non Interest Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Earnings Before Taxes 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Income Tax Rate ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0.0%
Income Tax Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Net Income to Common 0.00 0.00 0.00 0.00 0.00 0.00 0.00
End Common Equity/ Total Assets ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! 0.0%
Total Common Equity Year End 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total Liabilities Year End 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
FCFE 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Years of Discounting 0.5 1.5 2.5 3.5 4.5 5.5
PV of FCFE 0.00 0.00 0.00 0.00 0.00 0.00
Terminal Value ERROR:#DIV/0!
PV of Terminal Value ERROR:#DIV/0!
PV of Common Equity Fiscal Year End ERROR:#DIV/0!
Target Price at Fiscal Year End ERROR:#DIV/0!
Diluted EPS ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
3-month T-Bill

: Look this up on the WSJ or the US Treasury website Estimate of Future Beta

Wiggins, James: Your judgement, based on Yahoo betas of your stock and close competitors Cost of Equity 0.0000%
James Wiggins: We use a 7% market risk premium in CAPM

Wiggins, James: Change this row if the company has a different fiscal year end Latest diluted share count in milli

0—————

DCF Valuation in Millions $$$$$$$$$$$$$$$ Pro Forma in Action

12/31/18 12/31/19

12/31/20 12/31/21

Wiggins, James: Change this row if the company has a different fiscal year end

12/31/22

12/31/23

12/31/24

12/31/25

12/31/26

12/31/27

12/31/28

Total Assets Year End

0.00 0.00 0.00 0.00 0.00 0.00 0.00

Total Assets Growth Rate ERROR:#DIV/0!

ERROR:#DIV/0!

ERROR:#DIV/0!

0.0%

Interest Income/Avg Total Assets

ERROR:#DIV/0!

ERROR:#DIV/0!

ERROR:#DIV/0! 0.0%

Interest Income 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Interest Expense/Avg Total Liabilities

ERROR:#DIV/0!

ERROR:#DIV/0!

ERROR:#DIV/0! 0.00%

Interest Expense 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Provision for Loan Loss/Avg Total Assets

ERROR:#DIV/0!

ERROR:#DIV/0!

ERROR:#DIV/0!

0.00%

Provision for Loan Loss

0.00 0.00 0.00 0.00 0.00 0.00 0.00

Non Interest Income/Avg Total Assets

ERROR:#DIV/0!

ERROR:#DIV/0!

ERROR:#DIV/0! 0.00%

Non Interest Income

0.00 0.00 0.00 0.00 0.00 0.00 0.00

Order | Check Discount

Sample Essays, Assignments & Research Topics

Paper Writing Help For You!

Special Offer! Get 20-25% Off On your Order!

Why choose us

You Want Quality and That’s What We Deliver

Professional Writers

We assemble our team by selectively choosing highly skilled writers, each boasting specialized knowledge in specific subject areas and a robust background in academic writing

Discounted Prices

Our service is committed to delivering the finest writers at the most competitive rates, ensuring that affordability is balanced with uncompromising quality. Our pricing strategy is designed to be both fair and reasonable, standing out favorably against other writing services in the market.

AI & Plagiarism-Free

Rest assured, you'll never receive a product tainted by plagiarism or AI-generated content. Each paper is research-written by human writers, followed by a rigorous scanning process of the final draft before it's delivered to you, ensuring the content is entirely original and maintaining our unwavering commitment to providing plagiarism-free work.

How it works

When you decide to place an order with Nurscola, here is what happens:

Calculate Your Order Check Prices

Complete the Order Form

You will complete our order form, filling in all of the fields and giving us as much detail as possible.

Assignment of Writer

We analyze your order and match it with a writer who has the unique qualifications to complete it, and he begins from scratch.

Order in Production and Delivered

You and your writer communicate directly during the process, and, once you receive the final draft, you either approve it or ask for revisions.

Giving us Feedback (and other options)

We want to know how your experience went. You can read other clients’ testimonials too. And among many options, you can choose a favorite writer.