Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The purpose of this exercise is to construct a typical pro formal financial projection for a startup, and toconsider the financial implications for the venture.Your

The purpose of this exercise is to construct a typical pro formal financial projection for a startup, and toconsider the financial implications for the venture.Your tasks are as follows:1. Complete the spreadsheet by filling in numbers and computations (the yellow area). Do notchange the structure (columns, rows, headings, sheets). Note that you are working in monthson the cost sheet, annuals on the revenues sheet, and the P&L sheet. Year 0 is initial upfrontinvestment; Y1 represents development time; Y2-Y4 represent years that the app sells. Threeyears is the desired time horizon. Do not include taxes or financial expenses (loan interest, stockdividends). Do not add lines to the spreadsheet. The goal is to reach a conclusion regardinglikely cash flow from the venture on an ongoing basis. Be prepared to submit your spreadsheet.2. Please answer the following questions on a separate sheet of paper submitted through Canvas: What are the projected cash flows for the five years of the venture? State the final linefrom the P&L sheet and the cash flow line, for five years. State the final years profit orloss.

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_2

Step: 3

blur-text-image_3

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

Core Concepts Of Accounting Information Systems

Authors: Nancy A. Bagranoff, Mark G. Simkin, Carolyn Strand Norman

11th Edition

9780470507025, 0470507020

More Books

Students also viewed these Accounting questions