Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please see attached pictures. Essentially i have been given a data set with 15 customers. Jan monthly income was $70,982 Feb projections for monthly fee

Please see attached pictures.
Essentially i have been given a data set with 15 customers.
Jan monthly income was $70,982
Feb projections for monthly fee income are at $157,784
March only has 1 customer so far but i am sure to get more customers to increase this but right now i just dont have the data(need to know how to provide estimate)
if possible, please assist in making a graph that shows growth for this industry. it should be similar to the drawing detailed on my second attachment.
please provide steps to arrive at final line graph and provide detail on how to make the projection for march
please explain how to do so on excel and all steps provided would be helpful. thank you
image text in transcribed
image text in transcribed
END OF NEXT WEEK FEE Income (RO Je vo so you Fee Income MARCEL FFB JAN Subles GSW Income 5 estimates 07 Plex Ana col Ski zok, ya Toll 65 Feb EIR Ja 'Shayne Tird keh > 5047 Customer Name 1 Conneticut Co 2 Bengal Financial 3 GSW Safety 4 Capital Construction 5 Urban Mold 6 Fresh Express 7 Humboldt Foods 8 Kelly.co 9 Titan Express 10 Bowling Co 11 As Depo 12 Elle Financial 13 Manco 14 Federal Co 15 California Financial Monthly Fee Income Expected Date of Inflow/Outflow Month S36,000.00 1/31/2021 January $1,200.00 1/31/2021 January $300.00 1/31/2021 January $1,000.00 1/31/2021 January $32,482.00 1/31/2021 January Jan Monthly Fee Income $70,982.00 $1,200.00 2/15/2021 February $2,000.00 2/15/2021 February $24,500.00 2/15/2021 February $1,000.00 2/15/2021 February $1,200.00 2/28/2021 February $11.490,00 2/28/2021 February $4,000.00 2/28/2021 February $48.000.00 2/28/2021 February $64 394.00 2/28/2021 February Feb Monthly Fee Income $157,784.00 $12.812.00 3/31/2021 March March Monthly Fee Income $ 12,812.00 END OF NEXT WEEK FEE Income (RO Je vo so you Fee Income MARCEL FFB JAN Subles GSW Income 5 estimates 07 Plex Ana col Ski zok, ya Toll 65 Feb EIR Ja 'Shayne Tird keh > 5047 Customer Name 1 Conneticut Co 2 Bengal Financial 3 GSW Safety 4 Capital Construction 5 Urban Mold 6 Fresh Express 7 Humboldt Foods 8 Kelly.co 9 Titan Express 10 Bowling Co 11 As Depo 12 Elle Financial 13 Manco 14 Federal Co 15 California Financial Monthly Fee Income Expected Date of Inflow/Outflow Month S36,000.00 1/31/2021 January $1,200.00 1/31/2021 January $300.00 1/31/2021 January $1,000.00 1/31/2021 January $32,482.00 1/31/2021 January Jan Monthly Fee Income $70,982.00 $1,200.00 2/15/2021 February $2,000.00 2/15/2021 February $24,500.00 2/15/2021 February $1,000.00 2/15/2021 February $1,200.00 2/28/2021 February $11.490,00 2/28/2021 February $4,000.00 2/28/2021 February $48.000.00 2/28/2021 February $64 394.00 2/28/2021 February Feb Monthly Fee Income $157,784.00 $12.812.00 3/31/2021 March March Monthly Fee Income $ 12,812.00

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

Project Finance In Theory And Practice

Authors: Stefano Gatti

3rd Edition

0128114010, 978-0128114018

More Books

Students also viewed these Finance questions

Question

2. Use a point system or model papers when grading essays.

Answered: 1 week ago