Financial statement forecasting question?
Given the information below, how can I calculate the value for new debt capital (additional funds needed) and excess cash. I have calculated my forecast for the following year, but am having difficulty calculating new debt capital and excess cash.
INCOME STATEMENT
Sales9488.8
COGS5784.9
Gross Margin3703.9
Op. Ex.2689.7
Operating Income1014.2
Interest income
Interest expense (old)58.7
Interest expense (new)
Other expense34.1
Taxes331.7
Net Income589.7
Dividends
BALANCE SHEET
EXCESS CASH????
CURRENT ASSETS3625.3
PPE1618.8
OTHER ASSETS575.5
TOTAL ASSETS5819.6
CURRENT LIAB.1786.7
NEW DEBT CAPITAL????
OTHER LIAB.102.2
EXISTING DEBT435.9
PREFERRED STOCK0.3
EQUITY3494.5
TOTAL CLAIMS5819.6
http://tools.financial-projections.com/FreeTemplate.html
Industrial Rope Access
|
|
Memory Company Detroit Red Wings Melamine Chip and Dip Tray $24.99 You and your friends can come together to root on your favorite team, cheering for goals and eating chips, dip and cheese out of this NHL® melamine chip and dip tray from The Memory Company®. The 1-in x 14-in chip and dip tray is dishwasher safe and break resistant, perfect for parties with large groups of people. The officially licensed chip and dip tray is designed with the team logos and deco… |
|
|
These Hands(LP vinyl) $17.99 Side One: 1. These Hands 2. Let’s Talk About Love 3. The One You Say Good Mornin’ To 4. Weakness in a Man 5. And I’m Still Missing You Side Two: 1. (The Ballad of) Ole Sam 2. Us 3. Looks Like This is Gonna Be My Day 4. Aunt Maudie’s Fun Garden 5. Love Looks Good on You… |
|
|
SOFT LIGHTS SWEET MUSIC BOXED SET WITH 7 ALBUMS MORE THAN 80 SONGS…RECORDED IN DYNAMIC DIMENSION SOUND… |
|
|
Peltor H7A Optime 101 Over-the-Head Earmuff $16.91 Peltor Optime 101 Earmuffs, Green – Over-the-Head Model – H7A… |
|
|
MAX Kit – Complete Fall Protection Kit $103.00 Super Anchor safety is pleased to offer the MAX fall protection kit. It is designed to provide an easy solution for contractor safety by providing all needed items for fall protection in one unit. The products retain industry standard designs, extremely high quality and are cost effective. The kit includes Full body universal fit harness |
|
|
Msa Hi-Viz Orange V-Gard Class E, G Type I Polyethylene Non-Slotted Hard Hat $29.58 MSA Hi-Viz Orange V-Gard Class E, G Type I Polyethylene Non-Slotted Hard Hat With Fas-Trac Suspension… |
|
|
Green Tea 500mg By Jarrow – 100 Capsules Green Tea 500mg By Jarrow – 100 Capsules… |
|
|
Fixodent Denture Adhesive Cream, Food Seal, Plus Scope Flavor, 2 oz. $1.79 Use once a day for all day hold. Fixodent and forget it! Use once a day for all day hold with Scope flavor for fresher breath. It seals out food particles (vs. no adhesive) and has a precision tip nozzle to reduce oozing (vs. leading adhesive)…. |
|
|
Radnor 15 Long Bourbon Brown Leather Legging $56.00 Radnor 15″ Long Bourbon Brown Leather Legging With Spring Closure… |
|
|
Zhu Zhu Pet Hamster Boat & Dock $0.99 ! boat and dock that connects and adds to the Zhu Zhu Track System!… |
