Question: Question: *Make a Pro Forma Income Statement for 1 year. (Quarterly Basis; Q1, Q2, Q3, Q4) I am giving the data below : Assumption Sheet

Question: *Make a Pro Forma Income Statement for 1 year. (Quarterly Basis; Q1, Q2, Q3, Q4)

I am giving the data below :

Assumption Sheet
Rent Bdt40,000.00
Salary Bdt25,000.00
Maintenance cost Bdt4,171.37
Subscription fee(Price) Bdt1,200.00
Promotional cost Bdt15,000.00
Equipment{computer, printer,router,photocopier} Bdt34,000.00
Inflation Rate 4.99%
Currency rate Bdt85.45
Interest expense on bank loan 7.00%
Electricity Bdt10,000.00
BEPP for 2021
price per unit 1200
units sold 153.1214
total revenue 183745.7
fixed cost 113000
cost per unit 4.87
total cost 113745.7
profit 70000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Question Material j) Pro forma income statement (3 marks) Fizzy Pop bottles a lemon flavoured soft drink. All inventory is in direct materials and finished goods at the end of each quarter. There is...

Q:

Hi Vjvgoe, Are you able to help me with this problem please? I would need to see it 7/16/17 since it's due that same week but I will put the deadline on 7/29/17. I have attached all of the...

Q:

Please follow the materials under Project and build a master budget on an Excel spreadsheet for requirement 1. Modify the master budget in another sheet for requirement 2. Prepare a 1-page report for...

Q:

Please complete master budget excel worksheet per the instructions from the pdf document. Thank you! Buns Bakery Basic Information For Year Ended December 31, Year 2 Case Data Sales Information:...

Q:

Hello. Can you please help me fill out this excel master budget sheets (all tabs) using the instructions from the pdf attachment? Thank you! Buns Bakery Basic Information For Year Ended December 31,...

Q:

Please help me with creating a master budget for Frenchies regional bakery. Attached is the background and excel attachment to. Buns Bakery Basic Information For Year Ended December 31, Year 2 Case...

Q:

Please complete master budget excel worksheet per the instructions from the pdf document. Thank you! Buns Bakery Basic Information For Year Ended December 31, Year 2 Case Data Sales Information:...

Q:

Hello. Can you please help me fill out this excel master budget sheets (all tabs) using the instructions from the pdf attachment? Thank you! Buns Bakery Basic Information For Year Ended December 31,...

Q:

1. The Albany Youth Center (AYC) has an after-school contract with the city. Under the contract, MYC earns $3 per day for each child who uses the program. AYC served the number of children shown...

Q:

Required: 1. Base Budget Prepare a master budget for Lambda Inc. for the period covered by the annual contract (for the year and for each quarter). The following components must be included: a....

Q:

Use the accompanying Profit Analysis spreadsheet model to answer the following questions. Click here for the Excel Data File

Q:

What is the probability that a randomly selected point within the rectangle at right is in the orange region? The blue region? tiot --10. To

Q:

flexible budget is a budget that cannot be changed until the end of the fiscal year. an estimate of revenues and expenses that can be changed each month. a series of static budgets at different...

Q:

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".